Forum Discussion

CSpina's avatar
CSpina
Helper III
6 years ago

Show/ Hide visuals not working

Hi Guys.

I am creating a report where I have to hide KJPI if have no filter.

 

I created a measure:

 

 

 

Mostrar = CALCULATE(if(ISFILTERED('dMunicípios'[Nome_Município]),1,0), ALLSELECTED('dMunicípios'))

 

 

 

Which gives me 1 when I have a city (Municipio) selected.

 

 But, when I clear all selections, Mostrar =0, the KPIS show a list os cities.

Any clues?

 

Thanks in advance.

 

3 Replies

  • Define "Hide the KPI"  - Do you want to not show the KPI visual at all, do you want to show something else in its place, or something different?

    • CSpina's avatar
      CSpina
      Helper III

      s for your awnser.

      Hide means show no data or just blank.

      I want to show results when I have just one city selected.