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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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