Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
mattkocak
Kudo Kingpin
Kudo Kingpin

Turn your cards into slicers with Slicer Button!

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.

 

Using Slicer Button on CardUsing Slicer Button on Card

 

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

10 REPLIES 10
Henke6373
Frequent Visitor

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?

Detrelaa
Regular Visitor

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 

 

Visual Panel Missing  - cno functionality other than the cursor changing but clicking has no effectVisual Panel Missing - cno functionality other than the cursor changing but clicking has no effect

 

 

This 2nd one is from PBI descktop . Here all is working great.  Visual tab is present with the slicer options . Clicking works 

Same screen from PBI desktop  - here everything works as supposedSame screen from PBI desktop - here everything works as supposed

 

 

 

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?

 

mattkocak_0-1678895410955.png

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.

 

mattkocak_0-1679345460490.png

 

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 .

amitchandak
Super User
Super User

@mattkocak , Thanks for that.

 

Please post this on the blog too - https://community.powerbi.com/t5/Community-Blog/ct-p/PBI_Comm_CommunityBlog

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.