Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have multiple FY based on a attribute in a model i am facing the issue in sorting the visuals based on Months and Quarters.
Any help would be appreciated. Below is some demo data for the same.-
Customer Name | Sales | Amount | YearMonth | SortOrder |
AAA | 196 | 10 | 201807 | 1 |
AAA | 129 | 45 | 201808 | 2 |
AAA | 141 | 12 | 201809 | 3 |
AAA | 124 | 27 | 201810 | 4 |
AAA | 187 | 23 | 201811 | 5 |
AAA | 181 | 45 | 201812 | 6 |
AAA | 104 | 13 | 201901 | 7 |
AAA | 102 | 12 | 201902 | 8 |
AAA | 134 | 44 | 201903 | 9 |
AAA | 128 | 45 | 201904 | 10 |
BBB | 107 | 23 | 201804 | 1 |
BBB | 149 | 18 | 201805 | 2 |
BBB | 167 | 41 | 201806 | 3 |
BBB | 137 | 47 | 201807 | 4 |
BBB | 137 | 40 | 201808 | 5 |
BBB | 150 | 14 | 201809 | 6 |
BBB | 190 | 17 | 201810 | 7 |
BBB | 151 | 17 | 201811 | 8 |
BBB | 144 | 15 | 201812 | 9 |
CCC | 199 | 29 | 201810 | 1 |
CCC | 118 | 12 | 201811 | 2 |
CCC | 175 | 32 | 201812 | 3 |
CCC | 156 | 12 | 201901 | 4 |
CCC | 143 | 18 | 201902 | 5 |
CCC | 124 | 17 | 201903 | 6 |
CCC | 159 | 32 | 201904 | 7 |
CCC | 159 | 12 | 201905 | 8 |
CCC | 127 | 21 | 201906 | 9 |
CCC | 139 | 24 | 201907 | 10 |
Hi @Anonymous ,
What's your expected result? Do you want the records sorted by the value of column "SortOrder"? What's your issue? Could you please provide the relevant screenshots?
Best Regards
Rena
Hi @Anonymous ,
Please applied the field "SortOrder" as Tooltips field into column chart, and sort the visual data by this field.
Best Regards
Rena
Hi @v-yiruan-msft ,
I have tried that trick, but the problem with keeping the sort order to tooltip pane is it summarize the column(sort_order)
and could show the wrong sorting order.
Hi @Anonymous ,
Whether your problem has been resolved?
Best Regards
Rena
Hi @Anonymous ,
Could you please provide your sample PBIX file(exclude sensitive data) if it is convenient?
Best Regards
Rena
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |