Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I would like to create a measure or use another method that sets vertical lines at the beginning of each day in the following time series plot:
The date column has hourly values. I would like to have a vertical line indicating the difference between days, similar to the plot below (which I made in paint) - at the start of every day.
Is there a way of doing so? My current issue with time series graphs is that they are hard to read and it is hard to distinguish between different days.
EDIT: Seems like there is no way to do this. Power BI is trash.
This is a really basic requirement of a graph - a line at the beginning of each day. It should be so simple to implement. I find it ridiculous that Excel can't do this out of the box. What are Excel charts even for if they can't do something basic like this? Can we have a fix please?
@arie_energy , You can follow the suggestion from @Luuky
With a Date or number on X-axis , you get an option to have x-axis constant line too under the analytic pane with FX option, means you can add a measure or fixed date.
But 1 line will display as one point, so you have add A few
Yeah this really isn't going to work for me. I just want to have dynamically created vertical lines at the beginning of each day. My time series lasts a month so adding 30 vertical lines manually isn't going to help.
Hi @arie_energy ,
A quick tip to increase readability is to put on vertical gridlines.
Greeting,
Luuk
This does not help at all. This only helps when you display 5 days of data, but if its more it already skips a day. I am actually very disappointed by the fact that PowerBI doesn't have any capabilities of changing this.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 45 | |
| 41 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 64 | |
| 32 | |
| 31 | |
| 27 |