Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
Rnaval
Helper V
Helper V

Is there a way to rearrange the bars in a bar chart

Here's the Bar Chart which I would like to rearrange to instead show in the following order.

 

Critical

High

Medium

Low

 

Rnaval_0-1738912852797.png

 

2 ACCEPTED SOLUTIONS
wini_R
Resolver V
Resolver V

Hi @Rnaval,

 

You would need an additional column with sort order or a table similar to the one below to do that

wini_R_0-1738913631769.png

 

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:

wini_R_1-1738913839112.png

 

View solution in original post

v-fenling-msft
Community Support
Community Support

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:

vfenlingmsft_0-1739153836013.png

 

vfenlingmsft_1-1739153896521.png

 

vfenlingmsft_2-1739153921607.png

 


Close & Apply.


Then select the Serverity field in the Table view and click Sort by column, select the column you just added:

vfenlingmsft_3-1739153966827.png

 

vfenlingmsft_4-1739154018496.png

 

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.

View solution in original post

4 REPLIES 4
v-fenling-msft
Community Support
Community Support

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:

vfenlingmsft_0-1739153836013.png

 

vfenlingmsft_1-1739153896521.png

 

vfenlingmsft_2-1739153921607.png

 


Close & Apply.


Then select the Serverity field in the Table view and click Sort by column, select the column you just added:

vfenlingmsft_3-1739153966827.png

 

vfenlingmsft_4-1739154018496.png

 

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.

wini_R
Resolver V
Resolver V

Hi @Rnaval,

 

You would need an additional column with sort order or a table similar to the one below to do that

wini_R_0-1738913631769.png

 

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:

wini_R_1-1738913839112.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.