Forum Discussion

naoki's avatar
naoki
Helper I
7 years ago
Solved

Show as blank based on selection

Hi,  I would like to show numbers as blanks when a selection from a slicer is selected.  When I select buy, I don't need to see target. Similarly for certain country selection, I don't need to se...
Need Help
  • naoki's avatar
    naoki
    7 years ago

    v-yuta-msft 

     

    I managed to find the solution to hide based on 2 slicers, it is now showing blanks if I select either one or both choices. 

     

    Target = IF(ISFILTERED ('Table'[Col]),
IF(SELECTEDVALUE('Table'[Col])="Sell",  
IF(ISFILTERED ('Table'[Col]),
IF(SELECTEDVALUE('Table'[Col])="{CountryA, Country B}",  
CALCULATE([Target],USERELATIONSHIP('Table1'[Col],'Table2'[Col])),
BLANK()))
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

naoki ,

 

Have you dragged some to target field? If you have, the target value will be shown in the Gauge chart and can't be controlled by slicer.

 

 

Community Support Team _ Jimmy Tao

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

naoki's avatar
naoki
Helper I
7 years ago

v-yuta-msft 

 

I managed to find the solution to hide based on 2 slicers, it is now showing blanks if I select either one or both choices. 

 

Target = IF(ISFILTERED ('Table'[Col]),
IF(SELECTEDVALUE('Table'[Col])="Sell",  
IF(ISFILTERED ('Table'[Col]),
IF(SELECTEDVALUE('Table'[Col])="{CountryA, Country B}",  
CALCULATE([Target],USERELATIONSHIP('Table1'[Col],'Table2'[Col])),
BLANK()))