Forum Discussion

MilwTed's avatar
MilwTed
Frequent Visitor
4 years ago
Solved

Showing proper dates in column chart

Each column is a week of sales.  I would like the X-axis to display the Sunday date from each week for each column.  Currently is just lists months.  The dataset has a Sunday date, and the sales info for that week.  So for example from the picture

05/01/22 - $29.6

05/08/22 - $37.5

etc

 

Getting PBI to display the months is the closest I can get.  Thoughts on how to fix this?

 

2 Replies

  • HoangHugo's avatar
    HoangHugo
    Icon for Solution Specialist rankSolution Specialist

    Hi

    In the "X axis" edit, try to choose "Categorical"

    • MilwTed's avatar
      MilwTed
      Frequent Visitor

      Thanks, this worked.  Just a follow up -- I have the column set to short date format, but the chart still displays the long date.  Any idea how to get the chart to reflect short date?