Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Any help for Sorting based on a Slicer Value Section. Slicer will have the Column Names as List of Values used in a Table.
Solved! Go to Solution.
Hi,
Here is my test sample:
Please take following steps:
1)Create a slicer table by Enter Data:
2)Try this measure:
Measure =
SWITCH (
SELECTEDVALUE ( SlicerTable[Slicer] ),
"Sort by Date", RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( MAX ( 'Table'[Date] ) ),
,
ASC,
DENSE
),
"Sort by Target_Sales", RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( SUM ( 'Table'[Target_Sales] ) ),
,
ASC,
DENSE
),
RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( SUM ( 'Table'[Actual-Sales] ) ),
,
ASC,
DENSE
)
)
3)Add this measure to the table visual, and set this visual sort by above measure:
4)When selecting one value in slicer, the result shows:
See my attached pbix file.
Best Regards,
Giotto
Hi,
Here is my test sample:
Please take following steps:
1)Create a slicer table by Enter Data:
2)Try this measure:
Measure =
SWITCH (
SELECTEDVALUE ( SlicerTable[Slicer] ),
"Sort by Date", RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( MAX ( 'Table'[Date] ) ),
,
ASC,
DENSE
),
"Sort by Target_Sales", RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( SUM ( 'Table'[Target_Sales] ) ),
,
ASC,
DENSE
),
RANKX (
ALLSELECTED ( 'Table' ),
CALCULATE ( SUM ( 'Table'[Actual-Sales] ) ),
,
ASC,
DENSE
)
)
3)Add this measure to the table visual, and set this visual sort by above measure:
4)When selecting one value in slicer, the result shows:
See my attached pbix file.
Best Regards,
Giotto
@MKPBI_2805 , You have the option to choose a sort column, which means it is static. means no option to change.
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
What is that you want to achieve.
@MKPBI_2805 Don't think it is possible (As of today), to make sorting order by expression based (or selection based).
But will be interested in other community members thougts as well on this.
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |