Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |