Forum Discussion
Helper IICreating 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.
Community ChampionStore 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.
Helper IIHi Greg_Deckler Would you please suggest how can i Mark the image url as image url? Thanks.
- Greg_Deckler
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.
- Hasan_iba
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
- Greg_Deckler
Maybe something like:
CALCULATE(VALUES([Status]),FILTER(Table,MAX([Date])))
Let me check if this will work