Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

Issue with X-axis formatting

Hi All,

 

I have the below visual. The X axis is a timestamp which is in DD:MM:YYYY HH:MM:SS. I want it to just show Mon, Tue etc.. Currently it shows as 1 Jan, 2 Jan etc... When I change it to Day, it cumulates the BAR. How do I force it to show as Mon, Tues and not cumulate the value.

General Comment
Need Help
Show and Tell

1 Reply

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

    Hi Kolumam,

     

    Surely the values will be accumulated if the X-axis changes, or how can we analyse if there are many "MON"? The workaround could be adding another column which can make the weekday unique. Please refer to the snapshot below.

    Issue_with_X_axis_formatting

     

    Best Regards,

    Dale