Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Hasan_iba
Helper II
Helper II

Creating Colored Indicators

Hi Power BI experts. Hope you are all doing great. Recently, I am facing an issue with creating colored indicators as per the texts of a specific column. The issue I have is best summarized as follows: 

 

I have an application that collects project management data and snapshots it on a regular basis.  Our customers want to see reports that show how data changes over time.  If you look at this report on our website: https://www.shareadvance.com/report/?rpt=Project-Historical-Comparison that gives you an idea of what we need in this report.  That report compares numerical data, and you can see the current value next to a historical value.  You can change the date for the historical value using the slider.

The report we want to see will be based on data showing Projects and their health status.  The data is stored in text format, but the report needs to show this as graphical indicators.  The report will show historical health status based on a date chosen by the user.  Next to that it will show current health status based on the most recent snapshot like the following image: 

a.png

Here is the link to the pbix file I have : https://drive.google.com/file/d/0B0XwYvmbIN12REpUVXRGbG1ickU/view?usp=sharing

 

Is there a way to achieve what I am looking for? A prompt solution will be highly appreciated. Thanks

Hasan

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Store your indicators in a table with the URL to their image indicators:

 

Indicators

Indicator,IndicatorURL

Red,http://www.blahblahblah.com/red.jpg

Yellow,http://www.blahblahblah.com/yellow.jpg

Green,http://www.blahblahblah.com/green.jpg

 

Mark the image url as an Image Url in the data model. 

 

Relate your project status to this table on Indicator. Display the IndicatorURL in your table visualization.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

41 REPLIES 41

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors