Forum Discussion
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.
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.
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
Maybe something like:
CALCULATE(VALUES([Status]),FILTER(Table,MAX([Date])))
Let me check if this will work
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