Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sort by measure

Hello Team,

I have a custom "small multiple" chart in my powerbi workbook that uses the country as small multiples and different user count for these countries.

I need to order the country by Desc by Count of Users. "User Count" is from the related table.

Please help me.

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    HI Anonymous 

     

    Don't know if "small multiples" has this functionality enabled but try the below.

    The measure you use as Sort by has to be added to the visual, my case is a tooltip.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous,

    What 'small multiple' chart are you test? I found multiple custom visuals in power bi appsource. (AFAIK, some of the common visual features do not fully work on custom visuals if the visual authors forget to define them in visual design)

    In addition, it sounds like you want to order graph by multiple fields(value and category), current power bi only allows you to use one of them as sort order fields.

    Regards,

    Xiaoxin Sheng