Forum Discussion

kitti's avatar
kitti
Icon for Helper III rankHelper III
6 years ago
Solved

Control chart shows months

Hi experts,   I have a control chart which shows data by data point but I want to add grouped by months data to X axis as well.     Existing: only have data point as X axis   I would lik...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Add a calculated column with dax formula is : 

    MonthYear = FORMAT('Table'[Date_in],"mmm-yy")Date_in(data type must be date/time)

    Then use this column in the visual for the reporting.
  • kitti's avatar
    kitti
    6 years ago

    Hi All,

     

    I have tried but the result is still not satisfied. However, I negotiated with users to just have a tooltip for showing month, year.

     

    And this, I used Anonymous's calculated column to be on the tooltip.

     

     

    Thanks all for your suggestion,

    KL

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add a calculated column with dax formula is : 

MonthYear = FORMAT('Table'[Date_in],"mmm-yy")Date_in(data type must be date/time)

Then use this column in the visual for the reporting.