How to hide (or improve) blank charts?

[Galat198]

Hi,
I have some charts that I filter by date slicers like in the picture or others ...
Sometimes it happens that for a particular product there is no data for the chosen date
In that case, the empty chart only remains ..... it does not look good.

I tried to make an IF + ISBLANK formula and put a text or something in there but it doesn't work

What would you do in such a situation? How can I change data or do something (text, image, other...) when the chart is blank?

[parry2k · Accepted solution]

@Galat198 goal here is to overlay the image or kpi card and then change the color when no data found. See attached, it has two pages, one with a text message and one with image, change it as per your requirement.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Galat198 do you think something like this will work

[Galat198]

@parry2k  How do you do that ?? Maybe instead of "No Data Found " possible to insert another text or any image .....?

[amitchandak]

@Galat198 , if you try to replace measure value with some text, it will become a text measure. And will create a problem. As of now, I doubt you have any option for that.

[Galat198]

@amitchandak  Maybe it is possible to dynamically change this visual?

[amitchandak]

@Galat198 , that is possible using bookmark. But I doubt you can switch bookmark based on value.