Forum Discussion
Post ProdigyCreating Slicers for Monthly & Quarterly Data
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.
Super Userharirao , 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.