Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello.i want to rank my city based on their sales.
i've write following dax and it seems ok
rankx = RANKX(ALLEXCEPT(Table1,Table1[Region],Table1[Year]),[sales],,DESC)
it is ok in table.but i need to show only Max and Min of (city in respect to their) Rank in Bar chart axis.so I have:
max of rank = maxx('Table1',[sales])
the problem is that both of city appeared on bar char axis.
I've attached sample Dashboard and following pictures.
thank u
here is Dashboard Download link
@dombarg,
Please check the following modified PBIX file.
https://1drv.ms/u/s!AhsotbnGu1NokzxlG5iWHEUiNcKY
Regards,
Lydia
is there any way to calculate min of each group??
@dombarg,
Could you please post expected result in a table format or bar chart?
Regards,
Lydia
bar chart in picture is what i need,expect for the number of city code.
in bar chart in picture we want to show only 803 which is max.indeed,i want to how only max of city in each region in barh chart.
@dombarg,
Please check the modified PBIX file.
https://1drv.ms/u/s!AhsotbnGu1NokzQJzGzRT-TTrL7-
Regards,
Lydia
thank u .it is very nice and cool an simplebut there is still a problem.
when i change maxx with minx,it doesn't work and the result wont changed
indedd,i need to show both max and min in axis bar.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |