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

[Rnaval]

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

Critical

High

Medium

Low

[wini_R · Accepted 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:

[v-fenling-msft · Accepted solution]

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.

[v-fenling-msft · Accepted solution]

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.

[Rnaval]

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 · Accepted solution]

Hey @Rnaval,

I have applied the steps we suggested here and it works fine:

pbix file: https://www.dropbox.com/scl/fi/jnm53o11y3cre4uoymxjt/VM_pbiForum.pbix?rlkey=fulxo4afiz6rdp9ey668lzai...

[Rnaval]

Just a quick question, is there a way for me to format the total counts with a thousand separator? Meaning a comma if the number is in the thousands?

[wini_R]

Sure, just select your measure in Data pane and click comma seperator symbol in the top menu:

[Rnaval]

How do I access the menu you are showing? I don't see it.

[wini_R]

You need to select a related measure in Data pane first (1), then it switches to Measure tools tab (2) automatically. Last step it to apply the formatting you want (3)

[Rnaval]

Ok Thanks that worked for this chart but not for the chart next to it, any suggestions?

[wini_R]

The other chart does not include that same measure, actually it just includes a column. I'd suggest to create a measure and format it accordingly.

[Rnaval]

Great Thanks

[Rnaval]

Thank you very much, it's exactly the way I wanted it to look. 

Question - did you create a new table? Severity and Severity Order field, Is that a physical table in one of the spreadsheets or a logical table?

[wini_R]

I've created a (physical) helper table directly in semantic model (using Enter data method) which includes all the distinct values from Severity column and also added the sort order column, exactly same table as mentioned in my initial message

[Rnaval]

Thank you

[Rnaval]

https://www.dropbox.com/scl/fi/pufugkcw1wf2xchifxn8x/VM.pbix?rlkey=tnzrlcamwtj13cq22gj9pp74x&st=d76x...

https://www.dropbox.com/scl/fi/cbdd4d890cdtd7dpob141/Tenable-Extract.xlsx?rlkey=6dsa1z2x9e42pcb8ics0...

https://www.dropbox.com/scl/fi/jj1i45n3ucozi7u47mck2/38689-Master.xlsm?rlkey=ctgegjg0d7vspbhnaxkahjn...

https://www.dropbox.com/scl/fi/bwz36t9yas2n91t11wvib/19506-Master.xlsm?rlkey=s4zohvv6ji7tpbv3ls9w3sz...

https://www.dropbox.com/scl/fi/pj3vcwt1n2fn48kdhst9e/11936-Master.xlsm?rlkey=xq2n01o6b8rnsymv9dp3dje...

[wini_R · Accepted 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: