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.
I can sort numeric data in table or matrix. Some times, some numeric measure cannot be sorted on matrix.
Currently, I created line and clustered column chart that has the following:
-Shared axis : Fiscal Year, Month hierarchy for 12 month
-Column Values: MTD TY, MTD LY
-Line Values: MTD Trend Monthly
- Small multiples: top 10 Area based on TY sales measure (MTD TY)
I want to sort based on MTD TY as follows. It has done and not working correctly.
Solved! Go to Solution.
The sorting is ok with Tooltip field. Thanks.
My measure is write on Azure Analysis Service. It seems not working nurmeric measure sorting in small multiples.
@Thiri , Can you share what is wrong. This will be based on grand total MTD TY for each small multiple
@amitchandak Thank you for your reply. I want to sort small multiples by MTD TY Monthly as follows. But it cannot be sorted by MTD TY measures. I can choose it but the graph cannot sort actually. It only sorted by Area alphabetically. I think the small multiples cannot sort by numeric measures. Could you please suggest if there is anything wrong?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |