Forum Discussion

talkprem's avatar
talkprem
Icon for Helper I rankHelper I
2 years ago
Solved

Show or Hide a Slicer based on Report URL or button

Hi All,

 

Actually i am looking for a solution where i Show or Hide a Slicer based on Report URL or button.

I have a Region slicer which needs to be visible for a particular country is selected via report URL.

 

example - https://app.powerbi.com/groups/dfdsdfffsf/reports/sdsdsdnskn?filter=table1/countrycode eq 'country1' 

 

one country has regions but other country dont so can we show the slicer based on the report URL selection?

If this is not possible then how to create buttons to show or hide region slicer.

 

Thanks

Prem

Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi talkprem 

    You could add a filter to the slicer itself that returns the slicer title.

    Slicer Filter Measure =
    If(
    SelectedValue(table1[countrycode]) = "country1","Slicer Name", BLANK())

     

    Add this into the Filter Pane and filter to "Slicer Name" and also set the slicer header to this visual.

    Finally create a visual that makes the slicer backgroun transparent "#FFFFFF00" instead of blank.

    Above my Region = East Midlands so everything is hidden.

     

    Here the Region = London so the slicer is visible.

1 Reply

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    2 years ago

    Hi talkprem 

    You could add a filter to the slicer itself that returns the slicer title.

    Slicer Filter Measure =
    If(
    SelectedValue(table1[countrycode]) = "country1","Slicer Name", BLANK())

     

    Add this into the Filter Pane and filter to "Slicer Name" and also set the slicer header to this visual.

    Finally create a visual that makes the slicer backgroun transparent "#FFFFFF00" instead of blank.

    Above my Region = East Midlands so everything is hidden.

     

    Here the Region = London so the slicer is visible.