Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hey all,
If you're like me, then at some point you've wanted to use a card visual in Power BI as a slicer/filter. Yes, this can in a way be done natively through bookmarks, but there are some drawbacks to this. Bookmarks might affect other filters that you already have in place and you can't select multiple bookmarks at the same time.
If you want to avoid these drawbacks and have clicking your card function more similarly to the slicer visual, then you're in luck as I just developed a custom visual for this! It's called Slicer Button and allows you to apply multiple slicers at the same time with a simple click. In the example case described above, we simply use it as a transparent overlay on a card, which then gives the card the appearance of the ability to slice data.
A YouTube video is linked below that demonstrates how to download and use the visual as well as the GitHub repository that is hosting the visual.
Basic Setup & Use: https://www.youtube.com/watch?v=8x2QoE8M2yA&ab_channel=MattKocak
GitHub Repository: https://github.com/mattkocak/powerbi-visuals-slicerbutton
Additionally, below are two YouTube videos that demonstrate ways to extend the Slicer Button's usage.
Let me know if there are any questions or comments about this development. I'm happy to clarify or address anything.
Best,
Matt
This slicer is very nice.
In this way I could use a fixed slicer-value. But would it be possible to use wildcards as well?
In my situation I have a table with a field called [Title]. I need such a slicer for selecting all the rows where [Titles] contain the field "Consultancy", and not just equals "Consultancy".
Or is there another way of dealing with that?
Hello @mattkocak and thank you for this amazing slicer . Been using it quite a bit and it's been working awesomely .
Having issues getting it to work recently as the functionality is missing once published. Still debugging as I am unsure if t's a security reason or some update issue.
I saw the files are mnissing from the public repository. Is there an update coming ?
Hey @Detrelaa, glad to hear it's been of use. Would you mind describing the issue you're having in detail and providing some screenshots if helpful?
Hello @mattkocak and thank you for replying.
I added 2 screen shots from one of the reports I am using it in .
One is from the PBI Service - no fuctionality and missing Visual tab
This 2nd one is from PBI descktop . Here all is working great. Visual tab is present with the slicer options . Clicking works
Whats crazy is that it was all working fine mid last week .
I would greatly appreciate any suggetions.
Thank you
detrelas
Thanks for the info. I changed organizations recently and have limited access to Power BI right now so my troubleshooting is a little limited.
When I try to create a new report in Power BI Service and add the custom visual I get the following organizational error over the visual. Could it be that your organization also recently updated their Power BI policy and is blocking custom visuals?
Would you mind creating a new report directly in Power BI Service, importing the custom visual, and checking if you get the same error as me? Or maybe the custom visual works when you import it from scratch again?
Hello Matt,
I've tried this as well . No error message whatsoever and experiencing the exact some issue. The "Slicer Tab" from format your visual pane is just not showing up therefore removing the filter value . The button itself has the hover over effect and it seems to be clickable but the missing tab which contains the filter value is affecting it's functionality.
Hello again, I was able to test things out and didn't encounter the issue that you describe. I tried creating a report in PBI Desktop and uploading it to PBI Service. I also tried creating a report directly in PBI Service. Both times I was able to see the Slicer section of the format pane in PBI Service and everything was working as expected.
I'm not sure what the cause is on your end. There're no PBI updates that I'm aware of that would interfere with the visual. Maybe it's an organizational or report setting that's interfering with it. You could make sure that you're using the v1.0.2 release version of the Slicer Button, which is what I had tested with.
Unfortunately, I'm not able to help more with digging into this. Good luck with troubleshooting!
Thank you very much for the help. This makes it clear that the issue it's on the org security settings side . I will so some more dubugging .
@mattkocak , Thanks for that.
Please post this on the blog too - https://community.powerbi.com/t5/Community-Blog/ct-p/PBI_Comm_CommunityBlog
Hey @amitchandak,
Thanks for the suggestion. I posted this to the blog with the title Turn your cards into slicers with the Slicer Button custom visual.
Best,
Matt
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
85 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
66 | |
62 |