Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display image or text when there is no data?

Hey all,   I have a few reports up and running and when I start using slicers to display the different visuals by "department" I have noticed that some of the smaller departments have gaps in their...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Yes.  Just return your measure in a variable and then use IF() to return alternate text if blank.

     

    MyMeasure = var measure1 = [Original Measure]

    return IF(ISBLANK(measure1), "Not Enough Data", measure1)

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat 

 

Excellent I will give that a try!

 

What if instead of text I wanted to display an image? Is it the file path or url?

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You can use UNICHAR to return an image.  See this link - https://exceleratorbi.com.au/dax-unichar-function-power-bi/

 

Or you can just use the Windows key + the period button to insert an icon.  Insert it as text inside quotes like this "😊"

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat