Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am wondering if there is a way to select the order in which categories appear in a donut/pie chart. In my example below, the data seems to be populated randomly. (These are two different donut charts placed on top of the other). I would like the color ordering to be intuitive, like from one end of the spectrum to the other. Green --> light green ---> grey ---> light red --> red or vice versa.
The table below displays the data for the donut chart relating to specific capacity (outside ring of the above chart). I would appreciate it if anyone has any tips for this- I am relatively new to PowerBI.
W1-1 | -10% |
W1-2 | 10% |
W1-3 | 0% |
W1-4 | |
W1-5 | 30% |
W1-6 | 30% |
Solved! Go to Solution.
If you click the chart, there should be ellipsis on the top right (...). If you click that, you can sort your leged/axis.
If this doesn't work and you need to have a custom order sort. I would recommend creating a seperate table with 1 column of your attribute, and the other column with your custom order. Connect this table to your fact table on attribute, and you can then sort it based on your custom order.
If you click the chart, there should be ellipsis on the top right (...). If you click that, you can sort your leged/axis.
If this doesn't work and you need to have a custom order sort. I would recommend creating a seperate table with 1 column of your attribute, and the other column with your custom order. Connect this table to your fact table on attribute, and you can then sort it based on your custom order.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
82 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
111 | |
110 | |
72 | |
71 |