Show/Hide Dynamic filter based on data available

[NickzNickz]

Hi... I have below data in my table.

I want to create a dynamic filter to show/hide based data available.

Filter Page > Filter SubPage > Filter Project Name = Primary Title and Secondary Title

Output only show if Filter Project name is selected.

Scenario 1 : If I select Filter Page, if data exists in SubPage, Filter SubPage will show else hide.

Scenario 2 : If I select Filter Page, Filter Project Name will show if no data exits in subpage column.

Please help me ....
Regards,

NickzNickz

[Anonymous · Accepted solution]

Hi  @NickzNickz ,

According to your describe, currently it is not possible to make another slicer invisible based on the value in the slicer. But you can hide the slicer by making the value in this slicer empty and the font and background color transparent. You can follow these steps:

Here are my test data:

1.Create two measures

Measure_3 =
IF (
    SELECTEDVALUE ( 'Table'[Page] ) = "P3"
        || SELECTEDVALUE ( 'Table'[Page] ) = "P4",
    COUNTROWS ( INTERSECT ( VALUES ( 'Table'[SubPage] ), { BLANK () } ) ),
    COUNTROWS ( VALUES ( 'Table'[SubPage] ) )
)

Color_3 =
IF (
    SELECTEDVALUE ( 'Table'[Page] ) = "P3"
        || SELECTEDVALUE ( 'Table'[Page] ) = "P4",
    "#FFFFFF00"
)

2.Choose the Subpage slicer and configure visual settings

3.Configure the filter of this visual

4.Final output

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,

Albert He

[lbendlin]

I want to create a dynamic filter to show/hide based data available.

What's the business value of doing this?  Have your users asked for it?

[NickzNickz]

Hi @lbendlin ..

Yes... This is help page for dashboard FAQ..

Some of them feel confuse when they click but nothing happen. Current practise, when the user click page, but subpage is blank, the slicer subpage show nothing. Here is the measure i user which i found from youtube.

Check Filter Page = 
   ISFILTERED(d_page[Page]) && SELECTEDVALUE(d_page[Page]) = "Financial Highlights"

Hide Filter Subpage = 
   IF(
      [Check Filter Page],
      1,
      0
   )

To resolve the confusing, I plan to hide the slicer SubPage if not applicable.
Select slicer Page > If subpage available, than show slicer SubPage and hide if not applicable. > Show Slicer Title
Title () and Output () only show when Slicer page and/or Slicer Subpage is selected.
Clean view ... 

Regards,

NickzNickz

[lbendlin]

Consider using the Filter Pane instead and teach your users how to operate it.