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.
Hello, I have following problem.
In my report I am using hierarchical slicer with AND logic - solution presented in this article:
https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5
This is my data visualisation:
I want to know how many have fruits in selected colours, and I can do this. But now I want to know what are the other values for these filtered clients and I can't put my finger on which method I should use. Can anybody can help me with these?
Here is link to the pbix with example:
https://we.tl/t-b0cGih4nf2
Solved! Go to Solution.
Hi @DarSz ,
Since the original table has been filtered by slicer, you will need to copy it as an independent table.
Then create a measure like below and use it as visual filter.
mark =
var ids = CALCULATETABLE(VALUES(Client[ClientId]),
FILTER('Client', [HierarchySlicer Check] = 1))
return
IF(SELECTEDVALUE('Table (2)'[ClientId]) in ids,1,0)
Result:
Best Regards,
Jay
Hi @DarSz ,
Since the original table has been filtered by slicer, you will need to copy it as an independent table.
Then create a measure like below and use it as visual filter.
mark =
var ids = CALCULATETABLE(VALUES(Client[ClientId]),
FILTER('Client', [HierarchySlicer Check] = 1))
return
IF(SELECTEDVALUE('Table (2)'[ClientId]) in ids,1,0)
Result:
Best Regards,
Jay
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 |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
82 | |
72 |