Powe BI Small Multiples Sorting Issues

[Anonymous]

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 come at the top. By default in Power BI Value sort is available on column wise not on the row level. For referance attached the tableau same way its has to be done in Power BI.

Tableaue:

[Ritaf1983]

Hi @Anonymous 
Unfortunately, we don't have this functionality.
There is an idea about this issue; please vote for it here:
link

I voted + will share it with my colleagues in the user group that I manage.

As an alternative, you can use a Matrix with conditional formatting, which allows sorting by "Value."
However, there is a limitation: the sorting will be based on the total value, not for a specific year.

The pbix with the example is attached

Another option is to use DENEB to create the small multiples m but it cosideres some coding . 
Here is the guide :
https://www.youtube.com/watch?v=I6FZYTSKI6Y

You van also use advanced inforiver charts from market place , but this option is for pay :

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Akash_Varuna]

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

[grazitti_sapna]

Hi @Anonymous ,

In Power BI, small multiples automatically sort based on the axis values and do not provide an option to sort rows based on the measure (value). However, you can achieve the desired sorting (i.e., sorting rows by descending value in each small multiple) using the following workaround:

1. Steps to Sort Rows by Value in Small Multiples in Power BI
   Create a Rank Measure for Sorting

You need to create a measure to rank the values for each date segment in small multiples.

RankMeasure = RANKX(ALLSELECTED('Table'[GroupID]), CALCULATE(SUM('Table'[Value])), , DESC, DENSE)

Create a Sorting Column Since Power BI does not allow dynamic sorting in small multiples, you need to create a calculated column that assigns a sorting value.

SortOrder = 
RANKX(
FILTER(ALL('Table'), 'Table'[Date] = EARLIER('Table'[Date])),
CALCULATE(SUM('Table'[Value])),
,
DESC,
DENSE
)
This ensures that within each time period, the ranking is applied.

Sort the Y-Axis by the New Column

• Go to the Data view in Power BI.
  Select the GroupID column.
  Click Sort by Column and choose the SortOrder column.
  Apply Small Multiples

• Add Date to Small multiples.
  Add GroupID to the Y-axis.
  Add your measure (SUM(Value)) to the X-axis.
  Ensure that sorting is applied to GroupID using SortOrder.
• Alternative: Using a Matrix Visual
  If sorting within small multiples does not work as expected, you can also achieve a similar layout using a Matrix visual, where:

Rows: Group ID
Columns: Date (small multiples effect)
Values: SUM(Value), sorted in descending order.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[Anonymous]

In my scenario, we cant go with Matrix. Have to show the value based on Legand.

Given Dax fuction also not working as expected. Here we have Date granulatity function like below based on the filter selection it has to shown either Year, Quarter,Month and Week.

Date Granularity = {

    ("Year", NAMEOF('ShipOrderLine'[FISCAL_YEAR]), 0),

    ("Quarter", NAMEOF('ShipOrderLine'[FISCAL_QUARTER_ID]), 1),

    ("Month", NAMEOF('ShipOrderLine'[FISCAL_MONTH_ID]), 2),

    ("Week", NAMEOF('ShipOrderLine'[FISCAL_WEEK_ID]), 3)

}