Forum Discussion
Consistent Date X-Axis in Line Chart
Hi yosedesh ,
You can accomplish this desired result in the settings of the line chart:
For example:
This is what the line chart looks like:Click the line chart, and make the settings as shown in the figure below:
Set start date to 2023/10/1:Use this DAX to create a new measure and set the end date to today:
Today = TODAY()The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi yosedesh ,
Sorry when I review my reply, I find that I forgot to set the y-axis to start at 0. I changed the previous pbix file:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey yosedesh,
Just use a Date Dimension Date as your X Axis so that you get all of the dates. You may need to right click on the date field inside of the visual pane and select show items with no data. You may also need to add a date slicer so that you don't see all dates inside of your date dimension.
Here is a link to a public date dim from the company I work for:
Why Create a Date Table in Power BI? : :: Welcome To EPM Strategy ::