Forum Discussion
harirao
Post Prodigy
Post ProdigyCreating Slicers for Monthly & Quarterly Data
Hi All, I have two datasets—one with monthly data and another with quarterly data. Currently, the months are organized in columns, making it difficult to create a slicer for Month. Similarly, for t...
harirao , To create slicer first you need to Unpivot the data in Power Query
1. Load your data into Power BI.
2. Click on "Transform Data" to open Power Query Editor.
3. Select the columns that you want to unpivot (e.g., Jan, Feb, Mar for monthly data).
4. Right-click on the selected columns and choose "Unpivot Columns".
5. Rename the new columns as needed (e.g., "Month" and "Value").
6. Close and apply the changes.
hariraoPost Prodigy
Post ProdigyHi Team,
Could you please assist me with the request posted above?
Thanks!
Ashish_Mathur
Super User
Super UserHi,
Unpivoting is the way to go.