Forum Discussion

Anonymous's avatar
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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Any idea what kind of measure goes at the end ?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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's avatar
    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's avatar
      HashamNiaz
      Icon for Solution Sage rankSolution Sage
      6 years ago

      Hi !

      The measure will not behave as expected unless you have selected [All] option on your slicer / filters.

      Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        The [All] option is default so I cannot select it. Still not able to display (Blank) after trying your solution.