Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 trying to order descending in a graph. So, for example, the bar chart below should be from top to bottom value: 0.66%, 0.26%, 0.20%, 0.05%, -0.01% and -0.08%. And, if possible, conditionally formatting them too: green for positive values and red for negative ones.
Is there any way to do this?
Thanks,
Matheus
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:
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.
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
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
Hi @Anonymous ,
If you have submit a new idea, you could update the link here and accept your answer as solution. Others who need the requirement will find the answer quickly and vote the idea up as well. Hope it can be implemented as soon as possible.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |