Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dashboard

How do I get, in a dashboard, the x-axis to show individual date (12/01/2022; 12/02/2022; 12/03/2022; etc.) as the legend for the columns that appear above when my source Date field has hundreds of r...
  • amitchandak's avatar
    3 years ago

    Anonymous , Not very clear,

    But you can create a date table and use Axis Type = Categorical 

    New column

    Date  only = DateValue([Date])

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    According to your description, here are my steps you can follow as a solution.

    (1)We can create a calculated column.

     

    Date Column = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),DAY('Table'[Date]))

     

    (2)Format date columns.

    (3)Create a visual and place [Date Column] on the legend field and field selection for y-axis [count].

    (4)Set the x-axis type to "Categorical" and turn on "Data labels".

    Please refer to my PBIX file.

     

    Best Regards,

    Neeko Tang

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