Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |