Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kitti
Helper III
Helper III

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

1.png

 

I would like my control chart to show months of the data like this:

2.png

 

 

 

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

 

3.png

 

 

Any recommendation would be appreciated

Regards,

KL

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Add a calculated column with dax formula is : 

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

Then use this column in the visual for the reporting.

View solution in original post

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.

kitti_0-1597022560612.png

 

 

Thanks all for your suggestion,

KL

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Add a calculated column with dax formula is : 

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

Then use this column in the visual for the reporting.

@Anonymous 

 

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

 

Original result with data point

1.png

 

 

Result with MonthYear

2.png

 

 

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 , 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

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.

kitti_0-1597022560612.png

 

 

Thanks all for your suggestion,

KL

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors