Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rank multiple measures in a single graph

Hi, all!   I am struggling to find a way to rank different measures in a graph.    I have these measures, each one with a different formula but all of them are percentile values.   I am t...
Need Help
jairoaol's avatar
jairoaol
Icon for Impactful Individual rankImpactful Individual
5 years ago

To give you the order of the measures is only to add them in the graph in the values section in the order in which you want them to appear.

For the color theme:

  • When you have only one measure in the graph, you can set conditional formatting to apply colors as needed.
  • When you have multiple measures in the same graph, you can NOT apply conditional formatting to colors.
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for replying jairoaol!

     

    I guess I wasn't clear enough, sorry. I don't want to do this everytime, it suppose to be dynamic. When the values change, the order also changes. 

     

    And thanks for the info about the color theme! 

     

    Regards. 

    • jairoaol's avatar
      jairoaol
      Icon for Impactful Individual rankImpactful Individual
      5 years ago

      because graph only uses measurements, you can't sort it dynamically as you require.

      you must have some category field to sort (text fields, for example) according to the measure applied.

    • v-xuding-msft's avatar
      v-xuding-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      You could change the Y axis type to categorical to have a try. Then you could sort descending by one of measures.  Because there are many measure in your visual, please try the way to check if it can be a workaround.

       

      For contional formatting axis, unfortunately, it is not supported for now. There is a similar one. You could vote it up or you could submit a new one.

      https://ideas.powerbi.com/ideas/idea/?ideaid=299f0cbf-b628-48e5-833e-d4cc8dbc6718

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi, v-xuding-msft!

         

        First, thanks for replying. I tried this and unfortunately didn't work. I decided not to make this graph anymore. 

         

        But I will vote it up and submit a new one, it may help me in the future. 

         

        Thanks again and best regards!

         

        Matheus