Forum Discussion

Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
4 years ago

Small Multiples in Power BI

Hi all,

 

How can we sort the Small Multiples by a particular field which is not used in any of the fields in the chart?

 

Also, how can I give individual axes to these multiples? Beacause we are having one common axis for all the small multiples and if the value of one category is very high, then the other charts look very small.

Please help, or suggest any work arounds for this.

 

amitchandak , VahidDM , Anonymous , daxer-almighty 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Tanushree_Kapse , small multiple has a sort option in the latest version on the measure or on the small multiple columns. small multiple  can also be sorted on sort column if needed

    • Tanushree_Kapse's avatar
      Tanushree_Kapse
      Icon for Impactful Individual rankImpactful Individual
      4 years ago

      Hi amitchandak ,

       

      I am now using the custom visual Advanced Trellis Chart by Xviz for this purpose... because I needed to have individal axes for all the categories.

       

      Now for sorting, I've put the Order column in Group By field, the chart is now sorting properly....but the Order is also being displayed in the Title.

       

      Is there any waywe can remove or hide it from the title?

       

      Kindly help!