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
Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

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