Forum Discussion
Multiple line chart with continuous x axis date
Hi Everyone,
I have a line chart visual to compare perfomances year over year and the measure that I have is calculated per day. I need to show the entire year per day into de visual but I can't make it work (X-axis continuously).
If I add my Date from my DatesTable, I'm able to set x-axis type to continuous but it gets one year next to the other
In another post, I got the idea of formating the dates table diffrently:
Calendar date dd-MMM = FORMAT(DateTable[Date], "dd-MMM")
The result is ok but I need to fit the entire year in the visual and I can't.
I can make it countiniously with hierarchy - Month but as I mentioned before the measure is calculated per day.
As soon as I move my hierarchy level down to Date, the visual gets year by year next to each other.
Please find in this link the sample file.
Like this?
4 Replies
Should be straightforward.
Obligatory warning: Year Over Year comparisons based on the same date will be skewed as the date always falls on a different weekday. Best comparison will be by subtracting 364 instead.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, I included the sample file at the end in the original post.
Like this?
