topic Control chart shows months in DAX Commands and Tips

Control chart shows months

kitti — Fri, 07 Aug 2020 07:23:48 GMT

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,

Anonymous — Fri, 07 Aug 2020 10:42:57 GMT

Add a calculated column with dax formula is :

MonthYear = FORMAT('Table'[Date_in],"mmm-yy")

Then use this column in the visual for the reporting.

kitti — Fri, 07 Aug 2020 09:00:44 GMT

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,

amitchandak — Fri, 07 Aug 2020 10:28:08 GMT

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

kitti — Mon, 10 Aug 2020 01:26:44 GMT

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,