Forum Discussion

kitti's avatar
kitti
Helper 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

kitti's avatar
kitti
Helper III
6 years ago

Anonymous 

 

I just did it but the result is not what I want.

 

Original result with data point

 

 

Result with MonthYear

 

 

I want the data to show like the data point capture but the X axis shown as MonthYear capture. Could you please help?

 

 

Regards,

KL

  • kitti's avatar
    kitti
    Helper III
    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