Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Slicer Formatting

    Posted Apr 21, 2021 03:49 PM
    I'm trying to do something that seems so simple but is proving otherwise.  I have a report where I have ton of slicers in a slide-out panel I created.  Since I have so many of these (project requirement), I'd like to visually call out the ones in which a filter has been selected.  Could be a changed background color or even a bolded font for the selected item.  The dynamic formatting functionality for slicers seems to be broken and I can't get anything else to work either.

    Any ideas?

    Christopher Young
    Sr. Financial Systems Analyst

  • 2.  RE: Slicer Formatting

    Silver Contributor
    Posted Apr 22, 2021 01:41 AM
    You can try Chicklet slicer or else you have to make horizontal selection to get highlighted

    Krishna Nandan

  • 3.  RE: Slicer Formatting

    Posted Apr 22, 2021 10:27 AM
    Thank you, Krishna.  I don't think either of those will work for me, but you did give me an idea for something else to try.  I overlaid a small shape on part of the filter and dynamically formatted that.  I'm not sure if I like it or not, but it works.

    Christopher Young
    Sr. Financial Systems Analyst

  • 4.  RE: Slicer Formatting

    Posted Apr 22, 2021 09:27 AM
      |   view attached
    Hi Christopher,

    Are you showing filters on the filter pane?

    You can use "Applied filter" formatting:

    In power bi desktop open Page Formatting,
    -> Filter Cards -> type=Applied, then select background color for the filter card:

    Once you apply the filter, filter card will be highlighted with background color.

    If you want to do the same for slices, create a measure for each slicer, that will count how many filters are applied:

    How many filters applied =
    IF (
        ISFILTERED ( 'Dim'[Code] ),
        DISTINCTCOUNT ( 'Dim'[Code] ),

     where Dim[Code] is a field on the slicer

    Unfortunately, Background conditional formatting of a slicer is not working now.
    So I just put conditionally formatted shape behind the slicer, please see attached pbix


    Tetyana Yatsenko
    Reporting Analyst
    NewAge Industries, Inc.
    Southampton PA

  • 5.  RE: Slicer Formatting

    Posted May 19, 2022 10:39 AM
    Hi Chris.

    I have done something similar before when looking at making my reports more app-like (i.e. using icons that 'light-up' and stay lit when pressed). this is more for bookmarks though, not slicer as such... but here we go...

    It's a bit of a pain, but basically you can do this using buttons, bookmarks and then shapes overlaid over the buttons which are hidden when the button is selected. So you need a few elements, your icon or text that describes the action, two bookmarks, two buttons and a shape.

    Then all you do is have the buttons set to be completely transparent and have one to be 'this is what i want the target page to look like when I select it' and the other to be 'this is what the page looks like when it's unselected'. You need to use 'selected' visuals when setting up the bookmarks. I really go to town with it and have a bunhc of icon selectors and usually one page with all visuals, charts etc. on that then get hidden/revealed. The navigation is much smoother than the page navigation this way too.

    Might help!

    Paul Skuse
    Project Manager and Head of Analytics