Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @CSpina ,
You want to hide the card viusal when the measure return 0, am i right? Unfortunately, there is no such a feature to hide/show visiualization in a dynamic way. I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Dedmon Dai
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?
s for your awnser.
Hide means show no data or just blank.
I want to show results when I have just one city selected.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |