Forum Discussion
Solved
Data Formatting for Slicer
Hi All, TL;DR How can I create a slicer for both month and year? I'm a co-op student working on an accounting project for a company. The data that I am using is being pulled directly fro...
Hello MiekeV
If you apply a couple steps to your query you can get what you are looking for.
1. Unpivot value columns
2. Remove "Amount" from the month name
3. Add a Month-Year column
I have attached my sample file for you to take a look at.
I think, best is you transpose it in power bi using unpivot. Else you use union/summarize and create a new table merging all month in one.