Sorting Data in Different Order Based on Slicer Selection in Power bi
Hi Everyone, I want to sort the data in a specific order. When I select a value in the slicer. Below is the raw data: Table : Year Month Product Amount 2023 1 AA 100 2023 2 BB 200 2023 3 CC 100 2023 4 DD 100 2023 5 EE 300 2024 1 AA 300 2024 2 CC 500 2024 4 DD 600 2024 5 ZZ 300 2024 6 BB 300 slicer : order Required The order in which the products need to be sorted, when we select the year from slicer.Sorting Matrix Data Based on Slicer Selection
Hi Everyone, I want to sort the data in a matrix in a specific order. When I select a value in the slicer. Below is the raw data: The matrix visual contains Product and Value [Measure]. Raw Data Slicer The order in which the products need to be sorted depends on the year value selected in the slicer. Raw Data : Table Product Year Value P3 2023 100 P2 2023 200 P1 2023 300 P8 2023 40 P6 2023 100 P1 2024 200 P3 2024 300 P2 2024 40 P14 2024 100 P12 2024 200 slicer : Year 2023 2024 Required order, when we click on slicer : Order Required 2023 2024 Order order P1 P1 P2 P2 P3 P3 P6 P12 P8 P14
Matrix with drill down : Display certain rows based on slicer selection
I have a matrix table with level 2 , level 3 and level 4 in rows with drilldown option enabled, (Expand to next level using +icon) and product in column and Total in values, added a columnn BG in slicer. The ask is : If i select value A from the slicer i want level 2 and level3 values should display and level 4 should not be displayed in the matrix row. Level 2 should drill down to level 3. If i select value B from the slicer i want level 3 and 4 should display and level 2 should not be displayed in the matrix row. Level 3 should drilldown to level 4. Quick Snapshot of the visual. Please help me. Any solution with calculated columns or measures works
