Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi together,
I have a column chart and two levels on the X-Axis.
The Axis aren't concatenated and both levels are always shown.
Is it possible, to sort one axis by the value and the other one based on ABC for example?
I can only find a solution which works either the one or the other way.
Thank you and regards,
Andreas
Solved! Go to Solution.
One approach is to create a measure that generates a sort value that considers both the outer and inner dimensions in your visual. You then put the measure in the tooltips area of your visual, click on the ellipsis and sort by it. This example determines the total value at the outer dimension level and does the overall sort; the inner dimension is then sorted reverse alphabetically by name (but you could also use the measure value too).
NewSort =
VAR thisQty = [Total Qty]
VAR thisouter =
SELECTEDVALUE ( Stores[City] )
VAR thisinner =
SELECTEDVALUE ( Products[Subcategory] )
VAR outerrank =
RANKX (
ALLSELECTED ( Stores[City] ),
CALCULATE ( [Total Qty], REMOVEFILTERS ( Products[Subcategory] ) )
)
VAR innerrank =
RANKX ( ALLSELECTED ( Stores[City] ), Stores[City], thisinner )
RETURN
IF ( NOT ( ISBLANK ( thisQty ) ), 100 * outerrank + innerrank )
Pat
One approach is to create a measure that generates a sort value that considers both the outer and inner dimensions in your visual. You then put the measure in the tooltips area of your visual, click on the ellipsis and sort by it. This example determines the total value at the outer dimension level and does the overall sort; the inner dimension is then sorted reverse alphabetically by name (but you could also use the measure value too).
NewSort =
VAR thisQty = [Total Qty]
VAR thisouter =
SELECTEDVALUE ( Stores[City] )
VAR thisinner =
SELECTEDVALUE ( Products[Subcategory] )
VAR outerrank =
RANKX (
ALLSELECTED ( Stores[City] ),
CALCULATE ( [Total Qty], REMOVEFILTERS ( Products[Subcategory] ) )
)
VAR innerrank =
RANKX ( ALLSELECTED ( Stores[City] ), Stores[City], thisinner )
RETURN
IF ( NOT ( ISBLANK ( thisQty ) ), 100 * outerrank + innerrank )
Pat
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |