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.

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.