Show TEXT when Measure value is BLANK or FILTER selection is not active.

[DeeBali]

Hello Power BI Community!

I am a new DAX user and was hoping to get some assistance with my project. I have a Measure called MONTHLY INCREASE that is being calculated based on two other measures "DetectionDiff" and "PriorMonth Detections". However, MONTHLY INCREASE measure comes into play when one of the date filters is selected on my canvas (wither Month, Quarter or Year). Otherwise, the value shows BLANK and I have created a rule to turn the BLANK into dark color to match the anvas background so it appears to be invisible. However, what I really would like to do is, if the value is BLANK, instead of it saying so, it would day "SELECT DATE" so the user knows there is a visualization that needs their input for it to be displayed. Please help!

Thank you so much! 

[v-yanimei-msft · Accepted solution]

Hi @DeeBali  , 

Thank you for giving the concrete display example pictures. Based on your description, I think you can modify the measure as following steps to achieve the effect you want.

Please follow these steps:

1.Modify your MONTHLY INCREASE measure. Check if DetectionDiff or PriorMonth Detections is blank, and if so, return "SELECT DATE". Otherwise, it will continue to perform your existing MONTHLY INCREASE measure calculations. The modified DAX formula would look something like this ( Fill in the /* Your existing calculation for MONTHLY INCREASE */ part of the DAX statement with your measure MONTHLY INCREASE. ) :

MONTHLY INCREASE = 
IF(
    ISBLANK([DetectionDiff]) || ISBLANK([PriorMonth Detections]), 
    "SELECT DATE", 
    /* Your existing calculation for MONTHLY INCREASE */
)

2. Apply this modified measure to your visualizations where you want the "SELECT DATE" message to appear when no date filter is selected.

If you have any challenges or other issues implementing this solution, can you share the specific steps you have taken so far and the specific data you have used in text and image format? This will help diagnose the problem more effectively.

Best Regards,

Caroline Mei

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

[DeeBali]

Thank you so much. That worked! I was using the IF LOGIC and trying to complicate the formulae, I now know how ISBLANK syntax works! Have a great day!