Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have a combo chart, which uses drill throughs, as below:
Pic 1:
Pic 2:
As you can see, both axes are percentages. The secondary axis can only ever be a max of 100%, as it represents the amount of time in the month that has elapsed. The primary axis represents how much volume of our forecast we are expecting to consume; this axis can be both higher or lower, as you can see.
I want the two axes to be the same scale. I could force it with setting min & max, but if I set it too high it is unreadable when the bars are low. If I set it too low, I lose data.
I tried using a measure to create a max but, because I'm working with % fields, it's not quite working out. As you can see the scale cuts the bar too short (axis not high enough):
My last attempt:
Thanks for the help!
@dapperscavenger , You have option both can start with 0.
In the latest version you can control min and max Fx(means measure) so create a measure that can control that
Measure can changed based on need
oooh, never mind, it was actually better to just turn off all the axis options and revert to default !
Hi @dapperscavenger,
Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Yes, that was the measure I posted, but it does not work.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |