cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lubomirfranko
Frequent Visitor

Visualize timeseries curves with color gradient from newest to oldest

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:

Screenshot 2020-07-03 at 11.22.25.png

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!

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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. 

View solution in original post

1 REPLY 1
lbendlin
Super User III
Super User III

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. 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors