Forum

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

Hi Mattias, You need to add a column using the DATE function and rebuild the date using the year, month and day values e.g.: =DATE([Calendar Yea...

Hi Yuan, With a Microsoft 365 account you can use the new change tracking tool. Mynda

If you've got your data in a tabular layout then you can go ahead and create the PivotTables. You can add new responses to the original source data ta...