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.
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 |