Apologies all if I am missing something obvious or a simple solution.
I have created a number of cards returning a total from calculated columns and I would like the option to select it and the associated table is updated accordingly.
Unfortunately I cannot work out how to do this without using a separate filter, I thought this would just be automatic but no joy and cannot find a workaround.
Any ideas greatly appreciated.
Solved! Go to Solution.
I recently developed the Slicer Button custom visual that allows one to use a card as a filter (more specifically as a "slicer"). Using a bookmark has some drawbacks and this custom visual allows a card to be used more similarly to a slicer visual.
Below if a YouTube video demonstrating how to setup and use the visual as well as a link to the GitHub repository.
Basic Setup & Use: https://www.youtube.com/watch?v=8x2QoE8M2yA&ab_channel=MattKocak
GitHub Repository: https://github.com/mattkocak/powerbi-visuals-slicerbutton
I'm happy to clarify anything that's unclear regarding the visual. I also have a blog post on the topic titled Turn your cards into slicers with the Slicer Button custom visual.
If you found this post useful, it's helpful to me if you give it a thumbs up and accept it as a solution!
I think you want to click on the card and the table visuals will update somehow but that's not how filtering works.
The card total will be a measure but there's no logic to how that measure will affect data in the visuals.