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 line graph with a dynamic legend. How do I order the legend?
Same question for a matrix btw.
It looks like this:
And I have a table that kind of looks like this:
But I want the line graph ordered by month on the x-axis of course.
Solved! Go to Solution.
@Anonymous,
Given the sample data, you may take advantage of Id column.
@Anonymous,
Given the sample data, you may take advantage of Id column.
Create a calculated column in the same table as your Value field, which has the appropriate sort order - call it ValueSort
Then apply "Sort by columns" (from the modeling ribbon) to the Value column using the ValueSort column.
When you use the Value column in your visual, it will now be properly sorted.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |