Visualize timeseries curves with color gradient from newest to oldest

[Anonymous]

Hello,

We are working with timeseries data, that we read read from Azure SQL via DirectQuery. In PowerBI report, we use timeseries data to create line chart, showing perdiction for n-hours ahead. What I am trying to achieve is to plot NEWEST timeseries curve with always the same symbology. 

Let me exaplain. I have a Python mathematical model, that predicts something many hours ahead. At 12AM, the newest RUN is called [DATE_OF_RUN], 00. At 6AM, Python model starts again and it creates another prediction. Now the newsest RUN is called [DATE_OF_RUN], 06. At 12PM, Python returns run [DATE_OF_RUN], 12. 

So, at 6 AM, I have runs from previous day, but also run [DATE_OF_RUN], 00 and the newest RUN called [DATE_OF_RUN], 06. At 12 AM, I have runs from previous day, but also run [DATE_OF_RUN], 00 and [DATE_OF_RUN], 06 and newest run [DATE_OF_RUN], 12.

I am trying to set the newest RUN to always have certain symbology - eg. the newest run will always be the blue, thick line. Second newest RUN will be blue, dashed line etc. Lets's say we have x curves (timeseries) and we want the curves to have symbology color gradient-like. Newest line will be the darkest one, older runs will be continualy lighter.

This is how the report looks like now:

PS: milf is not what you think it is, those are initials of names of authors 😛 

Thank you for any suggestions and have a nice day!

[lbendlin · Accepted solution]

Since this is Direct Query you cannot use the usual Calculated Column workaround. You will have to ask your data source admins to (also) provide a view that shows the current/newest run with a fixed name.