Y axis order

[Jodes]

Is it possible to get $100,000 to $149,000 in the right place? Right now it's sorted by value.

[v-frfei-msft · Accepted solution]

Hi @Jodes ,

1. Insert an index column in power query.

2. Add the index column to tooltip and make the visual sort by index.

Pbix as attached.

[jdbuchanan71]

Hello @Jodes 

You will need a column on your data that has a number PowerBI can use to sort.  If you need, you can add a small table that has just your categories and the order, set the sort order on that small table, join it to your main data table and pull the categories from your small table.

You select the column you want to sort then, under the 'Sort By' drop down, pick the column you want to use.

If your table has two columns for the ranges you can use either the low or high to set the sort order and that will work also.

[Jodes]

Thanks @jdbuchanan71. I've got as far as creating the new table, but I am not sure who to merge. Can you point me in the right direction?

[jdbuchanan71]

Hello @Jodes 

Can you show me a sample of the fields you have on your main table, the one with the amounts you are adding up?

[Jodes]

@jdbuchanan71 

Here is a sample. The graph in my original question is displaying the total number of households for 5 visible minorities. 

Visible Minority	Income Level	Total Households
South Asian	Under $10,000 (including loss)	11215
South Asian	$10,000 to $19,999	10365
South Asian	$20,000 to $29,999	8605
South Asian	$30,000 to $39,999	7735
South Asian	$40,000 to $49,999	6285
South Asian	$50,000 to $59,999	4915
South Asian	$60,000 to $69,999	3760
South Asian	$70,000 to $79,999	2785
South Asian	$80,000 to $89,999	1890
South Asian	$90,000 to $99,999	1610
South Asian	$100,000 to $149,999	3895
South Asian	$150,000 and over	2085