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.
We have the CEO hierarchy as below and showing all the CEO types as different slicers.
CEO->CEO Minus 1->CEO Minus 2->CEO Minus 3->CEO Minus 4->CEO Minus 5->CEO Minus 6->CEO Minus 7->CEO Minus 8->CEO Minus 9
If I selected the combination of the lower Hierarchy CEO type and upper Hierarchy CEO types, I should get only the distinct count for the lower Hierarchy CEO type.
Ex:
CEO - A
CEO Minus 1 = A,B,C,D
CEO Minus 2 = B,E,F,G
CEO Minus 3 = E,F,H,I,J and so on...
Suppose we have selected the combination of
"A" from CEO slicer,
"A", "B" from CEO Minus 1 slicer and
"B", "E", "F" from CEO Minus 2 slicer.
We should get the distinct count as 3 from CEO Minus 2 slicer.
Thanks in advance.
Sanjeev
Solved! Go to Solution.
Finally after many work arounds I resolved this with switch function.
Intially I tried the switch function with CEO->CEO Minus 1->CEO Minus 2->CEO Minus 3->CEO Minus 4->CEO Minus 5->CEO Minus 6->CEO Minus 7->CEO Minus 8->CEO Minus 9
Later I realised the logic behind the switch function and reversed the CEO types to
CEO Minus 9->CEO Minus 8->CEO Minus 7->CEO Minus 6->CEO Minus 5->CEO Minus 4->CEO Minus 3->CEO Minus 2->CEO Minus 1->CEO
and it solved the issue.
Thanks for those who are looking into this solution.
~Sanjeev
I Tried all the work arounds and unfortunately not suceeded with the solution. Please help me on the solution.
Thanks in advance
Finally after many work arounds I resolved this with switch function.
Intially I tried the switch function with CEO->CEO Minus 1->CEO Minus 2->CEO Minus 3->CEO Minus 4->CEO Minus 5->CEO Minus 6->CEO Minus 7->CEO Minus 8->CEO Minus 9
Later I realised the logic behind the switch function and reversed the CEO types to
CEO Minus 9->CEO Minus 8->CEO Minus 7->CEO Minus 6->CEO Minus 5->CEO Minus 4->CEO Minus 3->CEO Minus 2->CEO Minus 1->CEO
and it solved the issue.
Thanks for those who are looking into this solution.
~Sanjeev
Hi @SanjeevKumar,
AFAIK, current power bi slicers use 'AND' logic to link different filters.
If you want to achieve the custom filter effect, please consider breaking the current relationship mapping and write a measure to extract the selection to apply the filter effect on the 'visual level filter'.
Applying a measure filter in Power BI - SQLBI
Regards,
Moonlight
Any particular reason for not using hierarchies and the PATH* functions?
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |