Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Here's the Bar Chart which I would like to rearrange to instead show in the following order.
Critical
High
Medium
Low
Solved! Go to Solution.
Hi @Rnaval,
You would need an additional column with sort order or a table similar to the one below to do that
Then you need to sort your severity column by that order column as described in this article:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
As the last step please make sure to sort the visual by the dimension and not the measure:
Hi, @Rnaval
I am glad to help you.
First click on Transform data, in the Power Query Editor you can add a new column to customize the sort order:
Close & Apply.
Then select the Serverity field in the Table view and click Sort by column, select the column you just added:
I have attached the pbix file for this simple example below, hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Rnaval
I am glad to help you.
First click on Transform data, in the Power Query Editor you can add a new column to customize the sort order:
Close & Apply.
Then select the Serverity field in the Table view and click Sort by column, select the column you just added:
I have attached the pbix file for this simple example below, hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For some reason it is not working for me, I'm attaching my data and pbix file so you can please have a look.
Hi @Rnaval,
You would need an additional column with sort order or a table similar to the one below to do that
Then you need to sort your severity column by that order column as described in this article:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column
As the last step please make sure to sort the visual by the dimension and not the measure:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
72 | |
63 | |
52 | |
49 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |