Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Aug 2, 2025
Topics: 0 / Replies: 4767
Reply
RE: Header bar question

Hi David, The icon configuration you're seeing is not because of your screen size. The first down arrow beside the Quick Access Toolbar icons revea...

2 years ago
Forum
Reply
RE: MMULT with AGGREGATE?

Hi Kenneth, I would think so, but it's a bit difficult to follow what your formula is doing without an example file because on the face of it, MMUL...

2 years ago
Reply
RE: Header bar question

Just confirming it's this (open the link to the image below rather than viewing this embedded image as it's distorted for some reason): If so, ...

2 years ago
Forum
Reply
RE: Header bar question

Hi David, Do you mean the box with the file name and the down arrow? If so, this is available with Microsoft 365 accounts. What version of Excel do...

2 years ago
Forum
Reply
RE: Why is my COUNTIF formula taking 8 hours to run?

Hi Chris, Why don't you try using a PivotTable to get the count? Insert a PivotTable with column G in the row labels and the values area, with the ...

2 years ago
Reply
RE: How to find the third Wednesday of each month?

interesting, Cedric! Thanks for sharing.

2 years ago
Reply
RE: 'Sketched' style quietly dropped?

Hi James, Disappointingly, Microsoft removed the sketched line style for charts. Apparently, there were some bugs that were too hard to fix. Myn...

2 years ago
Reply
RE: Translate using Google Translate

Hi Amanda, I'd probably try and do the translation before loading to Power Query and cleaning the data as it's best not to modify the query output ...

2 years ago
Forum
Reply
RE: Transform Data - Data Range Needed

Hi Deidra, Have you watched 7.01 Parameter Tables for Filtering? Let me know if you are still stuck after watching that and trying the techniques i...

2 years ago
Forum
Reply
RE: Sort Order by Legend for Stacked Column Chart

Awesome to hear! You won't miss that again

2 years ago
Forum
Reply
RE: Using the Card to show date with text

Hi Danielle, Write a measure like so: Today = "Performance Framework to: "&TODAY() Use that measure in a text box (see image atta...

2 years ago
Forum
Reply
RE: Sort Order by Legend for Stacked Column Chart

Hi Danielle, I wasn't able to download the Power BI file for some reason, but it'll be because you haven't set the Sort By for the Medals. See less...

2 years ago
Forum
Reply
RE: Create a custom column using the file date

Hi Danielle, Yes, if you use the Get Data > From Folder connector, at the Source step you'll find the meta data for the file, including the date...

2 years ago
Forum
Reply
RE: File from Onedrive: which path

Nice! Thanks for sharing, Ayal

2 years ago
Forum
Reply
RE: Refresh restores my formating

Hi Ayal, I suspect there is something in the columns that are changing that is driving the re-sizing because the Table properties setting should fi...

2 years ago
Forum
Page 12 / 318