cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Super User IV
Super User IV

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.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
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 IV
Super User IV

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.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Hasan_iba Helper II
Helper II

Re: Creating Colored Indicators

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

Super User IV
Super User IV

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.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Helper II
Helper II

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 IV
Super User IV

Re: Creating Colored Indicators

Maybe something like:

 

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

Let me check if this will work


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Helper II
Helper II

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 IV
Super User IV

Re: Creating Colored Indicators

Eh, kind of close, try this:

 

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

---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User IV
Super User IV

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])))

---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Hasan_iba Helper II
Helper II

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 Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors