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 like my control chart to show months of the data like this:

 

 

 

My data looks like this where 1st col is value, 2nd col is data point, and 3rd col is date

 

 

 

Any recommendation would be appreciated

Regards,

KL

  • 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

4 Replies

  • 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.