Forum Discussion
Y axis order
Is it possible to get $100,000 to $149,000 in the right place? Right now it's sorted by value.
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.
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
Super User
Super UserHello 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