Last seen: Jul 24, 2026
Hi Sunny, I don't think this is what Melissa wanted as she said: "I'm trying to capture the total "yes" responses for each option as well as the...
Hi Christoph, You can use the From Folder connector and then filter the list of files to only include the one you want to get the meta data from. ...
Hi Melissa, I've already given you the solutions to the DAX measure and age band grouping in the file I attached to my reply on November 17. As...
Hi Lesley, Welcome to our forum! Each year must be a separate series and you then set the series to 100% overlap. To achieve this, put each year...
Hi Michelle, If you look at the dates in the Actuals and Budget Excel Tables by selecting a cell and then viewing it in the formula bar, you'll see...
Hi Marko, Definitely better to have one big table with all your data, than split it into separate tables for each brand. Having separate tables for...
If you've pasted the data as values then the chart won't reflect any updates to the PivotTable, so not ideal as you'd have to copy and paste as values...
Hi Marko, No, the PivotTable will always display the prior period and the chart will always display the data from the PivotTable. If you add a Slic...
Hi Jet, Probably, yes. Just make sure your data is structured in a tabular layout and from there anything is easy. Mynda
Hi Mattias, It's probably ok to use the many to many relationship, but you'd want to do some spot checks to ensure it's reporting the results corre...
Hi Marko, Thanks for sharing your file. There is an easier way. Simply right-click an of the values in the PivotTable > Show Values As > Diff...
It's a side effect of using a PivotTable as the source for a pie chart when you have multiple axis labels/expandable fields. I'd try showing your boss...
Hi Mattias, In Power Query the process is the same except you use the #date function e.g.: =#date(year, month, day) Note: the formatting shou...
Hi Melissa, I appreciate it's not easy to follow written instructions. To clarify, I said: "After you unpivot it in Power Query, you 'close & l...
Hi Misha, Can I suggest you use a bar chart instead of a pie chart. You should never show more than 3 segments in a pie chart. Any more than that a...