mcolb88's avatar
mcolb88
Icon for Helper III rankHelper III
8 years ago
Status:
Needs Info

Bar Chart Date X-Axis Date including Time in Labels

I have a clustered column chart with a date filed as the x-axis. If the number of days filters down past a certain cutro-off the control starts showing 12AM and 12PM with teh date. This should not happen as there is no time conpoentn to the x-axis values. And labels no longer line up with the bars. Looks bad, please fix.Incorrect x-axis labeling for a date value

Reports

4 Comments

  • BiBra's avatar
    BiBra
    Icon for Helper III rankHelper III
    8 years ago

    I cannot seem to replicate this fault. However, I am curious how your date value is initialized? What does the core data day?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi mcolb88,

     

    Would you please share a pbix file with dummy data so we can try to reproduce it? 

     

    Best Regards,
    Qiuyun Yu 

  • mcolb88's avatar
    mcolb88
    Icon for Helper III rankHelper III
    8 years ago

    HI,

     

    Attached is a very straight forward example of this issue. I striped the report down to a simple calculated date table and a call log. If you filter the date to include 10 days for example, the chart looks correct with expected date labels in the x-axis.

     

     

     

    However, if you filter down to 5 days, you will see the time appended to the x-axis date label.

     

     

    Even after changing the format of the date column to use m/d/yyyy, it still shows the times of 12 AM and 12 PM.

     

    Thanks

     

     

Completed Ideas