Want to Display "No Data Available" message in card if both two measure value is blank.

[sagarsahoo_123]

Hi Team,

Request for help to assist one requirement. In my bar graph if two of measures value is blank or zero, it should display "No data Available" message. I tried with one measure blank is working fine but the condition is not working for two measures .

If you look at the above picture, i want to show message " No Data Available" like right bottom if my measure [Nippon HC] & [DigiAct HC] is zero or blank.

Please help to resolve. Many thanks in advance.

Regards,

Sagar

[Greg888 · Accepted solution]

I did something similar to display a message box over the table/graph should the user select no values from the drop down. I put the return from the measures in card  and put it over the table.

I set a conditional formating of the text Callout value to be the same colour of the background IF the number from the Measure is 0 (thereby hiding it when there is data). 

The background of the card has to be transparent.

I created a measure like this:

No Data = VAR GetData = COUNT(Nippon HC)
Return
IF(ISBLANK(GetData),"No Data available",0)

[sagarsahoo_123]

Hello,

Thanks for your quick support.

But if you look at my earlier posted picture where in the table i have already created two measures like [Nippon HC] & [DigiACT HC] .If the value of this two measures are blank or zero, then only the "No Data Available" message should be displayed in the below Graph.

Regards,

Sagar

[Anonymous · Accepted solution]

Hi @sagarsahoo_123 ,

Please update the formula of measure [No Data] as below and check if it works or not...

No Data =
IF (
    (
        ISBLANK ( [Nippon HC] )
            || [Nippon HC] = 0
    )
        && (
            ISBLANK ( [DigiACT HC] )
                || [DigiACT HC] = 0
        ),
    "No Data Available",
    ""
)

Best Regards

[sagarsahoo_123]

Hello,

Thanks a lot for such a quick response. It solved the problem.

[Greg888 · Accepted solution]

I did something similar to display a message box over the table/graph should the user select no values from the drop down. I put the return from the measures in card  and put it over the table.

I set a conditional formating of the text Callout value to be the same colour of the background IF the number from the Measure is 0 (thereby hiding it when there is data). 

The background of the card has to be transparent.

I created a measure like this:

No Data = VAR GetData = COUNT(Nippon HC)
Return
IF(ISBLANK(GetData),"No Data available",0)