Single Line Graph dynamically displaying data?

[nsadams87xx]

Hey everyone,

I have a line graph that is displaying Ranks over Year Quarters for different facilities.  However, some facilities don't have a "Rank", the data just simply isn't being collected.

Is it possible to have my line graph display data in the following way:

If If rank is not available for a facility, display Score on the line graph instead.

[Anonymous · Accepted solution]

Hi @nsadams87xx ,

You can write a measure to check current rank and add a calculation to summary score to replace blank result.

Regards,

Xiaoxin Sheng

[nsadams87xx]

I figured it out.  THank you.

[nsadams87xx]

Thank you Xiaoxin.  So use an If statement then?