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.
Hi,
I have a set of data with Counties and States that I am sorting by total customers, but when drilling down I would like the order to stay uniform. I would like the order to stay High, Moderate to High, Moderate to Low, and Low and not sort by Total Customers. Is this possible?
Solved! Go to Solution.
Hi @Anonymous ,
Step1, Add two columns in "Power Query".
Step2, Use 'Sort by column' feature sort the columns.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , you need to have sort column for customer type(High, Moderate to High, Moderate to Low, and Low) and then sort the matrix on rows .
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Thanks for the response @amitchandak! I do have a sort column for the cutomer type. But I want to keep the sort as overall by total customers, and just sort the drill down from High to Low. For example since KY - Jefferson has the most customers it would be the top, but when I drill down it would go from high to low customer type no matter how many subs are in those categories
Hi @Anonymous ,
Step1, Add two columns in "Power Query".
Step2, Use 'Sort by column' feature sort the columns.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |