Show or Hide a Slicer based on Report URL or button

[talkprem]

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

[SamWiseOwl · Accepted solution]

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.