Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a problem and looking for a solution for the same -
I have one variable name as Categories of furniture, initially I got the counts of this unique categories and then I ranked this variable based on counts. Now sorted teh same in descending order. The values whose rank is "1-3" the precode will remain same but from 4 till end rank the name of the precode will be "Others".
First I generated a Stacked chart keeping "Date in x-axis" and categories in Y-axis the data should be trailing 6 months (means if I click on slicer(Date) August'2022 then in chart x-axis bars should be Mar'22-Aug'22. And in Legends I have droppeed Rank Precode variable in whick based on the Latest month I will get Top 3 + 1 (Others) legends.
Problem:
1. Trailing 6 months chart
2. If I click on one legend (Suppose A) then based on the selection, other charts in the view should be changed. If I clieck on "Other" then also the other charts legends should change based on the selection
3. Point 2 is possible If I dnt have others
All other charts are also top 10, top 5, top 3 on different variables
Below are my DAX -
Calculated column DAX 1:
Hi @SK87 ,
Please share some sample data and expected result.
Best Regards,
Jay
User | Count |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |