Forum Discussion

yosedesh's avatar
yosedesh
New Member
2 years ago
Solved

Consistent Date X-Axis in Line Chart

Hello:   I'm trying to display a trend line using a line chart for various Users.  The line chart defaults to showing the number of records for over 250 Users, but there is a User slicer so that pe...
  • Anonymous's avatar
    Anonymous
    2 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.

  • Anonymous's avatar
    Anonymous
    2 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.