DrillThrough - If blank show text message "No Data"

[uSt]

Hi Team,

I have to show one page based on DrillThrough concept and if data NOT available need to show as "No Data Found".

Please help me.

Thanks,

uSt

[amitchandak · Accepted solution]

@uSt , When you are drilling through, you have value on the page and if that is used in the drill page you can not have a blank.

You can have transparent background using conditional formatting and have no data image in the background 

if(isblank(countrows(Table)), "FFFFFF", "FFFFFF00")

You can have image with no data keep them in background of visual

and then use this measure in background conditional formatting so that it get displayed when there is not data.

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[uSt]

@amitchandak ,

Conditional format -> in the table one, right? (not the card visual "No data")