slicer hide and show based on blank and values

[Anonymous]

Hi Guys, Need help on this..
 1. if slicer has the blank() and values , then slicer should show
2. if slicer has the only blank , then slicer should hide(slicer should not show)
3. if slicer has the values then slicer should show

1. Notes-3 slicer Should  show- because , it has Blank and Values.                 

    
2. Notes-4 slicer Should Hide  - Because , i have only blank value

3. Notes -5 slicer Should not hide (Should show) - becasue , i have the data 

[Anonymous]

Hi Folks, Any help regarding the above ask

[Anonymous]

Hi, @Anonymous 

You can refer to the PBIX file I provided, it will achieve your needs.

Best Regards

Jianpeng Li

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

[Anonymous · Accepted solution]

Thank you Kedar_Pande 

Hi, @Anonymous 

According to your description, I have the following data sets and table relationships:

First, I created two slicers:

I then created two measures using the following expressions:

SlicerA = IF(COUNTROWS(VALUES(TableA[A]))=0,"#FFFFFF","#000000")

SlicerB = IF(COUNTROWS(VALUES('TableB'[Slicer]))=0,"#FFFFFF","#000000")

Use them in the slicer header:

The results are as follows:

Have values: show

Have values and blank() : show

Only have blank() : hide

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[Anonymous]

Thanks @Kedar_Pande , I tried but no luck ,with this measurs , nothing is showing in slicer but not hiding the slicer.. the ask is , it should hide ,, any help ?

[Kedar_Pande]

Instead of visual level filter, you can add conditional formatting to the header and value

[Kedar_Pande]

Create a measure:

SlicerVisibility = 
IF(
ISBLANK(MAX('YourTable'[YourSlicerField])),
"#FFFFFF", "#FFFFFF00"
)

• Option 1: Use a card or KPI visual to show or hide based on the SlicerVisibility measure. You can overlay a blank slicer image or text when the slicer only contains blanks to simulate the hiding effect.
• Option 2: Apply the measure as a visual-level filter for the slicer, setting the filter to 1 to show the slicer when it contains values and 0 to hide it (or apply an overlay).

[Anonymous]

I tried Pande conditional formating too but no luck . it is not working ..