Last seen: May 14, 2025
Hi Tom, It's not really what Power Query is designed for. Power Query is for gathering and cleaning data ready for that data to be analysed/summari...
I presume you're using Excel 2016 like those above, Susan as it's working for me in 365.
Hi Carolyn, These are Power BI Service features only. For insights you need to have your data in the cloud for the AI to reference it and return in...
Hi Susan, Welcome to the forum. It's great to see you're practicing. The data table is in the file called pp_3_superstore_before.xlsx which is t...
Hi Mark, The best way is to create the 'Current Holdings' table in a separate workings sheet and then use the SORT function to bring the table into...
Hi Mark, When you plot data on a secondary axis it scales the axis to suit the values it's plotting while making use of the available space, as a r...
Hi Mark, You would have to load your data to the Power Pivot data model and write a DAX measure that ignores filters to retain the rank percentages...
Our pleasure, Deirdre. Glad you've found a workable solution.
Hi Deirdre, I'm not aware of any way to change the default from grey. This was deemed a best practice design feature as the key is for your data to...
Hi Tim, All files for the course are in a zip file available to download from the top of the course syllabus page. Let me know if you have troub...
Hi Lenny, It’s great to see you’re practicing. In the lesson for 3.04 Slicers for Formulas, you see the first thing I do is insert a PivotTable bas...
Hi Genevieve, Thanks for the screenshots. I suspect it's the accent over the 'e' that is causing the issue. What happens if you insert a step befor...
Hi Genevieve, Great to hear you're enjoying the course! I can't see the error message in the screenshot. Can you please click in the white space...
Hi Ashley, The behaviour described in issues 1 and 2 is not something you can change. The best you can do is educate the user. You could use the te...
Hi Sarfraz, Presumably you have each formula in a separate cell, with the final formula referencing the previous or helper formula. If so, you can ...