cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular 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

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Visualize timeseries curves with color gradient from newest to oldest

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
Highlighted
Super User V
Super User V

Re: Visualize timeseries curves with color gradient from newest to oldest

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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors