Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to Solution.
Add a calculated column with dax formula is :
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
Add a calculated column with dax formula is :
@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
@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.
Thanks all for your suggestion,
KL
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |