Forum

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...

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...

Nice! Thanks for sharing, Ayal

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...

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...

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...

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...

glad I could help!

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...

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...

Hi Teja, Yes, VBA would be the only way to do this. There are no built-in settings for Excel to detect the size of a screen. The only other opt...

Hi Emmanuelle, Go to PivotTable Options > Layout & Format tab > For empty cells show: N/A Mynda

Hi Joachim, You can use Power Query to do this as explained here: Compare two Excel Lists with Power Query. Mynda

It'll be a floating point problem. Although what you see in the cell might be 200.000000' for example, in the actual underlying XML file it's probably...

From what I remember, the shape map charts in Power BI are fairly limited. You might be able to write a measure that filters the results displayed in ...