Hide a slicer based on selection of values in another slicer in power BI

[PradeepSpowerbi]

Hi,

I have a requirement below .

report type - realized and unrealized .

if I select Realized as value in the slicer then another slicer with realized date should be visible but if I select unrealized the slicer should be hidden.

how to achieve it ? 

[PradeepSpowerbi · Accepted solution]

Hello , 

thank you so much for the solution . It works . However I need to hide the slicer itself when unrealised is selected .

Thanks !

[bhanu_gautam]

@PradeepSpowerbi For this create a measure 

SlicerVisibility =
IF (
SELECTEDVALUE('Table'[ReportType]) = "Realized",
1,
0
)

Add the second slicer (Realized Date) to your report.

Add a card visual to your report and place the second slicer inside this card visual.

Select the card visual and go to the "Format" pane.
Under the "General" section, find the "Visibility" option.
Set the "Visibility" to be controlled by the measure you created (SlicerVisibility).

[PradeepSpowerbi]

Hello ,

I have created the measure accordingly but I don't see the visibility option under format . Can you pls help 

[bhanu_gautam]

Add that measure as filter and set property like this

[PradeepSpowerbi]

Hello ,

Thank you . It works if I add that measure as a filter in the slicer . Seems like card visual is not required .

But if I add a date column as a slicer it is not working as expected . 

[PradeepSpowerbi]

 

[PradeepSpowerbi]

 

[v-xingshen-msft]

Hi ALL,
Firslty  bhanu_gautam thank you for your solution!

And @PradeepSpowerbi ,Based on your question, I tried to make some example data to replicate your problem, would you mind checking my pbix file and maybe it can give you ideas,.
If the data has deviation from you, you can also modify on my example data to reproduce your problem, in this way, it will be convenient for us to provide you with a more perfect solution, I hope it will be helpful to you!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[PradeepSpowerbi]

Hello ,

Thank you for the solution . However it works only with tile slicer and not the actual slicer visual . I tried replacing the existing tile slicer with normal slicer which shows as calendar date option but it is still not working sir .

Thanks !

[v-xingshen-msft]

Hi @PradeepSpowerbi ,

I'm sorry that I didn't fully understand your needs at the beginning, if the standard slicer reference with the date column, there is indeed an unrecognizable problem, this may be due to the limitations of this state of the slicer, the following is the solution we have given, we use the bookmark to operate, we will be recorded in two different situations to realize the slicer We hope you find it helpful!

Here is my updated pbix file, hopefully my solution will help you with your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.