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 see in this link: https://drive.google.com/file/d/0B0XwYvmbIN12REpUVXRGbG1ickU/view?usp=sharing
You can find the historic status column in the history compare table. History compare>historic status (that contains the image url)
This is what I am seeing in the HistoryCompare table. There is nothing called Historic Status. There is ProjectHealth. Also, I do not see an image URL. What am I missing?
hi Greg_Deckler check in this link: https://drive.google.com/file/d/0B0XwYvmbIN12Uzc1Y2pub1hlTjg/view?usp=sharing
this file contains the historic status column in the history compare table. If you could suggest a way to find a solution regarding the last requirement I posted, it will be amazing. I have already bothered you a lot. Looking forward to the desired solution which I believe is not far. Thanks
These three measures seem to work and you put the last measure into a Table visualization along with Project[Name].
HistoryCompareLastDate = MAX(HistoryCompare[HistoryDate]) HistoryCompareLastStatusMeasure = TOPN(1,VALUES(HistoryCompare[Historic Status])) HistoryCompareFinalLastStatus = MAXX(SUMMARIZE(Project,Project[Name],"Last Date",[HistoryCompareLastDate],"Status",[HistoryCompareLastStatusMeasure]),[Status])
Now, here is almost your real problem. You can't flag a measure as an Image URL. Therefore, create the last Measure instead as a Calculated Column in Projects table. Or create a calculated column in Projects that is simply:
ProjectFinalLastStatus = [HistoryCompareFinalStatus]
But, your real problem is that you are missing a relationship between Projects table and HistoryCompare so you need to add that based on ProjectUid. Once you do that, this will work as described.
hi Greg_Deckler its almost there but slight issue. Whenever I select a date on the timeline, the current status value also gets changed. But i want the 9th may values for project status to stay fixed even if i select other dates on the timeline. the following image should clarify:
Here you can see that the value of the current status column is changing. but the current status is the status for 9th may which should be fixed even if i change date on the timeline. This is the final problem i am facing. Thanks a lot
Try this one:
HistoryCompareFinalFinalLastStatus = MAXX(SUMMARIZE(Project,Project[Name],"Last Date",CALCULATE([HistoryCompareLastDate],ALLEXCEPT(Project,Project[Name])),"Status",CALCULATE([HistoryCompareLastStatusMeasure],ALLEXCEPT(Project,Project[Name]))),[Status])
Hi Greg_Deckler the issue unfortunately persists. I am afraid, there might not be a proper solution to this