cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hasan_iba Regular Visitor
Regular Visitor

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

Accepted Solutions
Super User
Super User

Re: Creating Colored Indicators

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

41 REPLIES 41
Super User
Super User

Re: Creating Colored Indicators

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Hasan_iba Regular Visitor
Regular Visitor

Re: Creating Colored Indicators

Hi @Greg_Deckler Would you please suggest how can i Mark the image url as image url? Thanks. 

Super User
Super User

Re: Creating Colored Indicators

Go into your data model (middle icon on the left) in Desktop. Click your column. Click "Modeling" tab in the ribbon. In the ribbon in the Properties area you will see Data Category. Drop down and click Image URL.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Regular Visitor
Regular Visitor

Re: Creating Colored Indicators

Hi @Greg_Deckler thanks a lot for the solutions. I need one more suggestion. I also need to find the current status of projects based on the status of the most recent date. How can i achieve this? Thanks again

Super User
Super User

Re: Creating Colored Indicators

Maybe something like:

 

CALCULATE(VALUES([Status]),FILTER(Table,MAX([Date])))

Let me check if this will work


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Regular Visitor
Regular Visitor

Re: Creating Colored Indicators

Thanks @Greg_Deckler. What i need to have is the most recent date for each of the project and then extract the status of the project on that specific date and keep it fixed and not have it changed if other parameters are changed using slicers. Thanks

Super User
Super User

Re: Creating Colored Indicators

Eh, kind of close, try this:

 

Measure = CALCULATE(TOPN(1,VALUES('Calendar'[Month Name])),FILTER('Calendar',[Date]=MAX([Date])))

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User
Super User

Re: Creating Colored Indicators

Whoops, didn't see that latest requirement, try this:

 

Measure = CALCULATE(TOPN(1,VALUES('Calendar'[Month Name])),ALL('Calendar'),FILTER('Calendar',[Date]=MAX([Date])))

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Regular Visitor
Regular Visitor

Re: Creating Colored Indicators

I will try these out but I dont want to calculate from the date table,. I want to calculate from the history compare table of the dataset. 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,039)