Hello
I have forecast data in the following format:
I want to create a PivotChart (so that I can change the grouping of the timeline) where the horizontal axis will be the timeline and the vertical axis will be the percentage values above with a slicer to choose a whole category or a specific Subcategory.
Is that straightforward to do or I have to use power query?
Thanks!
I have forecast data in the following format:
Category | 01/01/2021 | 02/01/2021 |
Subcategory1 | 24% | 43% |
Subcategory2 | 18% | 13% |
I want to create a PivotChart (so that I can change the grouping of the timeline) where the horizontal axis will be the timeline and the vertical axis will be the percentage values above with a slicer to choose a whole category or a specific Subcategory.
Is that straightforward to do or I have to use power query?
Thanks!