Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Removing X axis values from chart

I have a report where I am tracking production values daily and putting them on a line graph. I have this by calendar day and I want to be able to have a bookmark where the user will be able to switc...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    Create a calendar table using below dax expression:

     

    Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

     

    Then create relationships between the 2 tables.

    Last in the line chart,use the calendar date as the X -axis,and you will see:

     

    For the related .pbix file,pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

     

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

Create a calendar table using below dax expression:

 

Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

 

Then create relationships between the 2 tables.

Last in the line chart,use the calendar date as the X -axis,and you will see:

 

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!