Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date's in visual

Hello, 

 

I have this visual below where i would like the x axis to read 03/06/2019 instead of 3 etc. 

 

 

 

 

 

 

 

 

 

 

 

 

Is there a way to change this? 

 

Thanks, 

Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

     

    If you use the hierarchy to the column of date like the first picture, you have to remove it firstly. And you  can reference the following way. If I understand incorrectly, please post your sample data.

    Choose the Fields -- > change the Date Hierarchy to Date -- > click Format -- > X axis -- >change type to Categorical

     

    Best Regards,

    Xue Ding

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    If you use the hierarchy to the column of date like the first picture, you have to remove it firstly. And you  can reference the following way. If I understand incorrectly, please post your sample data.

    Choose the Fields -- > change the Date Hierarchy to Date -- > click Format -- > X axis -- >change type to Categorical

     

    Best Regards,

    Xue Ding

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.