Forum Discussion
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:
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
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.
41 Replies
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.
Hi Greg_Deckler Would you please suggest how can i Mark the image url as image url? Thanks.
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.
Perhaps if you put it in the correct format, "file:///" but that would not work if publishing to the Service. In addition, if you shared the PBIX file with someone, they would have to have access to that file location or have those files in the same spot as you.
