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
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can try to create some measure as following then use them in card visual to meet your requirement:

 

New_Measure_Countrow =
IF (
    CALCULATE ( COUNTROWS ( 'Table' ), ALLSELECTED ( 'Table' ) )
        = CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table' ) ),
    BLANK (),
    [Old_Measure_Countrow]
)

 

New_Measure_Sum =
IF (
    CALCULATE ( COUNTROWS ( 'Table' ), ALLSELECTED ( 'Table' ) )
        = CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table' ) ),
    BLANK (),
    [Old_Measure_Sum]
)

 

Replace [Old_Measure_Sum] with the measure you used in the card visual, 'Table' should be replaced with the table name of your fact table.

 


If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared?

 

BTW, pbix file as attached.


Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am not sure how to add the [Old_measure] . Please see my screenshot below. What am I doing wrong ? Thanks.

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      Sorry for our delay in reply, What is put inside the card visual, measure or summarize of filed? If it is a measure , use the measure , if it is a sammarize of field , such as count, use Count('Table Name'[Field name]).


      Best regards,

       

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      How about the result after you follow the suggestions mentioned in my original post? Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

       


      Best regards,