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.
Hello,
I was able to sort my data with Month-Year labels, but I want to do a further sort for the actual categories in the legend (so the yellow category, which is a proprietary service starting with a V, comes after consulting). Any ideas? Thanks in advance!
Hi there,
You should be able to manage this using the sort by column features. For example, you could add a conditional column in your query (or a column in the data model using, say, a SWITCH statement) that assigns a value as follows:
If you then select your [Deal Type] column and change its sort by column to the conditional column you added in your query (or in the model), the legend and chart composition should respect this. You just need to make sure that your sort by values are unique for each distinct value in your [Deal Type] column.
Good luck!
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |