Custom sort on bar chart

Can you please guide me on how to sort the categories in this visual to blank,poor, fair, good, very good, excellent?

image

Hi @BM_Girlracer,

Add a sort order column to the table these categories are from and use the Sort By option.
That should do it

I hope this is helpful.

can you please guide me on how add a sort order column or provide a link to the resource? I tried to search but couldn’t find it.

Hi @BM_Girlracer,

A solution depends on how that table was created…

If it’s a supporting table and you’ve used “Enter Data” to create it, go to the Query Editor, select the Source step and add the column in the displayed dialog box

If it’s an externally sourced table you have 2 options:
First in Power Query , go to the Add Column tab and select “Conditional Column”
Second in Data view add a New Column using the DAX SWITCH/TRUE statement

I hope this is helpful.

Thanks! I’ve added a conditional column :slight_smile:

@Melissa, will you be able to help with the measure to me get the rating for this?

image

I’ve attached the excel file on how to calculate the rating. Calculation.xlsx (10.3 KB) I don’t know how to apply it in power BI.

Hi @BM_Girlracer,

As this is a new question and unrelated to this topic, please create a new thread and supply a sample PBIX with the mockup you’ve already created.

Thank you.

Will do thanks!

Dear @BM_Girlracer
I think these two videos would also be helpful,