How to Display (Blank)

[Anonymous]

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

.

[v-lid-msft]

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]

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

[v-lid-msft]

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,

[v-lid-msft]

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,

[Greg_Deckler]

Perhaps measures structured like the following:

Measure =

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

[Anonymous]

Any idea what kind of measure goes at the end ?

[Greg_Deckler]

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]

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]

Hi !

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

Regards,

[Anonymous]

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

[Greg_Deckler]

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

[HashamNiaz]

Hi !

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

Regards,

[HashamNiaz]

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]

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

[HashamNiaz]

HI !

You click;

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

Regards,