Dynamically Hide/Show Slicers based on other slicer selection

[Gokulg]

Hi,

I have Month, Start Date and End Date filter in filter pane , if i select any values in Month filter (IsFiltered() = True) then Start Date and End Date filters should be hidden automatically, if i remove selection in Month filter (IsFiltered() = False) then Start Date and End Date filters should be visible automatically. Is there anyway to achieve this?

I tried in filter pane but not able to achieve this, so i hidden entire filter pane and moved all filters to Slicers (designed custom filter pane usng Shapes, Slicers and Bookmarks). Here i created a Measure to know Month value is filtered or not and also another measure to make a control transperent like below,

Make Transparent = IF([Is Month Filtered] = False,

"#FFFFFF00", -- returns transparent if Is Month Filtered is False

"White")

I added a Rectangle shape and in color property i added this Measure to mask the Start Date and End Date when Month filter is selected. So in this way i can able to acieve hide/show Dates but if i click Date the above rectangle is not allowing, if move rectangle to bottom in selection, then Dates are always above the rectangle and visible.

Please help me to acieve this

Thanks,

Gokul

[Gokulg]

Hi @Anonymous ,

Sorry for late reply, i already tried the above method which you mentioned but when we use filter visual effects using row cards. The row cards will only display the values and not able to edit, my requirement is to change the date ranges so that is not possible in row cards.
Anyway the requirement is removed. Thanks for update

[Anonymous]

HI @Gokulg,

I found a blog that told how to control the visibility of visuals based on filters effect, you can take a look at the following link if helps:

Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

Regards,

Xiaoxin Sheng

[lbendlin]

"if i select any values in Month filter (IsFiltered() = True) then Start Date and End Date filters should be hidden automatically, if i remove selection in Month filter (IsFiltered() = False) then Start Date and End Date filters should be visible automatically"

I understand that someone might request you to implement that, but do they have a good reason for that request?  Why should you need to spend time on this?