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.
I have what seems like a simple issue, but can't figure it out and can't find it here on the forums. I need my slicer to show how many items are part of each slicer value, and have that number change as filters are applied. I found a partial solution, which shows the total number of items, but it's not responding to filters.
So for example, this shows the number of items for each slicer value in the base data set:
But if I change my date slicer and reduce the size of the data, the numbers on the slicer don't change:
Based on how I designed it (which was based on a thread I found in the user forums), I understand why it doesn't change, it's just counting the base data set, but I can't figure out how to make it dynamic. It can't be too hard, I just don't know my DAX well enough yet. Can anyone please help? .pbix is here: https://drive.google.com/file/d/1GWU9JEDbBJhwaT9thhMGc1jLA8ozjhtu/view?usp=sharing
thanks!
Solved! Go to Solution.
Hi @Anonymous ,
The calculated column can not get the slicer value dynamically. Unfortunately, your requirement can't be implemented. There is no workaround after testing.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
The calculated column can not get the slicer value dynamically. Unfortunately, your requirement can't be implemented. There is no workaround after testing.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm afraid that this won't work. I tried it with a calculated table but the slicer is not changing.
BR,
Josef
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |