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 (Blank) as my default data before I use my filters to select what I want to see. Please see my screenshot. Thanks

.

Need Help
Tips and Tricks

15 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Perhaps measures structured like the following:

     

    Measure =

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

    • 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
        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]))

         

         

  • 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,

         

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    6 years ago

    Hi !

    You are trying to halt the report execution before user made any selection;

    Try using [Select & Apply] settings for slicer so everytime a slicer has been chaged user has to manually press the [Apply] button.

    This setting could be option & settings;

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi , can you show me how you got to that screen ? I'm in Power BI Desktop and I don't see it.

      • HashamNiaz's avatar
        HashamNiaz
        Solution Sage
        6 years ago

        HI !

        You click;

        File -> Option & Settings -> Options -> Current File -> Query Reduction

        Regards,

         

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    6 years ago

    Hi !

    You can think of implementing RLS so only users who have access to data will be able to see the information.

    Regards,