Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Powe BI Small Multiples Sorting Issues

In Power BI Small multiples, Date column in Small multiples and Group ID  in Y-axis. If we develop in the same way we not able to sort value in Desc order like the row which have highest value should...
Need Help
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Anonymous You could create a Measure which calculates the maximum value for each group and then use this measure to sort it 

  • Create a Measure for Sorting: Define a measure to calculate the maximum or total value for each group

    Sort Measure = MAX('Table'[Value])

  • Sort Small Multiples by Measure:

    • Go to the small multiples field pane.
    • Select the field and sort it by the created measure.
      If this post helped please do give a kudos and accept this as a solution
      Thanks In Advance