Forum Discussion
Y axis order
Hi Anonymous ,
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.
Hello Anonymous
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.
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?
Hello Anonymous
Can you show me a sample of the fields you have on your main table, the one with the amounts you are adding up?
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