Forum Discussion
Consistent Date X-Axis in Line Chart
- Anonymous2 years ago
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. - Anonymous2 years ago
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.
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.