Control chart shows months

[kitti]

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 · Accepted solution]

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.

[Anonymous · Accepted solution]

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]

@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

[amitchandak]

@kitti , Create a date hierarchy as per your need. And then in drill down use expand(reverse square Y) and try

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[kitti · Accepted solution]

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