Replacing blank in visual on conditional data

[BernW]

Hi, 

I have a source table similar to the example:

Records      Is good

AABB          True

BBAA          True

CCAA          True

DDAA         False

I have a table in my desktop that returns a record against a slicer however I only want the reposnse to come up when the 'Is good' column is true, which i have a acheived through a simple filter on the table. So now when i select 'DDAA' from the slicer, the table is blank. I would prefer the returned result is 'not available; as that's more accurate than what looks like missing data. I can't alter the source data and add extra columns as it's connected to multiple other data models. Is there a way to change the blank to 'not availbale'? As there is data in the column the isblank function doesn't apply. 

[v-angzheng-msft]

Hi, @BernW 

I tried to reproduce the results mentioned in the above blog, I hope it will be helpful to you.

I created a simple sample. There are no sales for the 2015 year, so there is no data to show.

1. Create a measure for no data:

_No data = if(ISBLANK(SUM('financials'[Profit])),"No data for the selected criteria","")

2. Display it in red font on the card visual. Turn off the category label, the background, visual headers, border etc. to make it just a pure text in the report

3. Open the selection pane and place the card at the bottom of the bar chart.

4. Place the card and bar in a group

Done, this is the final result.

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18 · Accepted solution]

Hi @BernW ,

You can try approch which is mentioned in below article. Hope it will help you to get desired output.

https://radacad.com/showing-an-alternate-text-when-no-data-available-in-a-power-bi-chart-visuals 

Thank you,

Samarth