Forum Discussion
How to Display (Blank)
Hi all, I am new to Power BI. I built a dashboard using slicers and Cards as my visualizations. I would like my cards to show as (Blank) instead of showing numbers. Is there a way to display (Bla...
Any idea what kind of measure goes at the end ?
Well, if you are currently using a measure for those visualizations, let's call it "My Measure", then you would do this:
Measure =
IF(COUNTROWS('Table') = COUNTROWS(ALL('Table')),BLANK(),[My Measure])
If you are displaying a column of values and using a default SUM aggregation, you would do this:
Measure =
IF(COUNTROWS('Table') = COUNTROWS(ALL('Table')),BLANK(),SUM('Table'[MyColumn]))