Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to get $100,000 to $149,000 in the right place? Right now it's sorted by value.
Solved! Go to 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.
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.
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.
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 @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?
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |