Forum

Hi David, I don't know of a way you can do this, however if the issue is that you don't want to see zeros in your spreadsheet, then you could use a...

This is ok for small tables, but I wouldn't do that on tables with upwards of hundreds of thousands of rows.

Hi Yuan, There's no built in way to do this, but this VBA code will list all PivotTables and their fields, so you can see which field name isn't me...

Hi Sari, This is a common locale issue. i.e. you've opened the file in a different locale to the one it was created for. You can use Power Query to...

Hi Stacy, Welcome to our forum! I'm not familiar with any Visio books or resources I could recommend, sorry. Perhaps someone else here knows more a...

Hi Susan, When you write a measure in a table as an added column there is no need to explicitly qualify the table name since this is implied. What ...

Hi Genevieve, I'm not sure what you mean by "all the months which don't start with the same three letters cause problems". Can you please share the...

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.