Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Apr 23, 2025
Topics: 0 / Replies: 4761
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
Reply
RE: Filter data between files

Hi Ayal, Thanks for clarifying. I don't recommend links to external workbooks. Instead, use Power Query to bring the Plots List data into the Dusti...

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

Hi Ted, You can use the same formula, choose Wednesday from the data validation list to return the first Wednesday, and then add 14 days to take yo...

2 years ago
Reply
RE: Filter data between files

Hi Ayal, I'm not sure what you mean by 'plots', nor how your data is laid out. Can you please provide an example file that shows the data, and your...

2 years ago
Reply
Reply
RE: Avoiding warning message when linking 2 files

Hi Ayal, The lookup formulas are bringing data in from an external file. With Power Query you can use the Get Data > From File connector (lesson...

2 years ago
Forum
Reply
RE: Function Suggetion not working correctly

Hi Ayal, I happened to see a video of this by fellow Microsoft MVP, Wyn Hopkins the other day. You can watch the solution/explanation here. Mynd...

2 years ago
Forum
Page 12 / 318