Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to adjust X Axis based on data values

Hello All,

 

I am working on a vizualisation (line chart) where the Time period on X axis  is not aligned to the data. Below is the screenshot - The date range selected on slicer is 4/20 to 5/11 and I see same data for April and May in my line chart. My problem is the X axis on line chart is showing dates from July 2017 and the actual values in May are looking very small to the corner on chart and making it hard to read also. How can I adjust the line chart X axis so that the dates on X Axis start from April.

 

Need Help

2 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    8 years ago

    Create a Date dimension table, make a relationship to your data/fact table.

     

    Use the datetable[date] field for your x-axis, and your slicer should also use the same. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    If you want the dates on X-axis to be dynamically changed corresponding to date range selection from slicer, please add the same date column from the same table or related date columns from two tables.

     

    Regards,

    Yuliana Gu