Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Tips and Tricks

Community Champion

6 years ago

Perhaps measures structured like the following:

Measure =

IF(COUNTROWS('Table') = COUNTROWS(ALL('Table')),BLANK(),<some calculation goes here>)

Anonymous

Not applicable

6 years ago

Any idea what kind of measure goes at the end ?

Greg_Deckler
Community Champion
6 years ago
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]))
Greg_Deckler
Community Champion
6 years ago
Well, if you're currently using a measure for those visualizations, let's call it "My Measure," then you'd do this:

Measure?

IF(COUNTROWS('Table') ? COUNTROWS(ALL('Table')),BLANK(),[My Measure])

If you display a column of values and use a default SUM aggregation, you would:

Measure?

IF(COUNTROWS('Table') á COUNTROWS(ALL('Table')),BLANK(),SUM('Table'[MyColumn]))
- Anonymous
  Not applicable
  6 years ago
  I have this written but its not working. Am doing something wrong ?
  Thanks,
  
  Measure = IF(COUNTROWS('Products Data') ,COUNTROWS(ALL('Products Data')),BLANK(),SUM('Products Data'[YTD # of New Core Accts]))
  - HashamNiaz
    Solution Sage
    6 years ago
    Hi !
    The measure will not behave as expected unless you have selected [All] option on your slicer / filters.
    Regards,

Related content