cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jaydpie
Helper IV
Helper IV

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 data because they are very small... so there are a few of the visuals that are just blank. Is there any way to provide some indicative text like "No Data Available" or an image? Just so that its clear that its not "broken"

 

Cheers,

J

1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Super User
Super User

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

@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?

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.