Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Experts
Once again I seek help of experts here with regard to the display unit for data labels.
I want the line to show in % but the column in Millions. Is that possible?
When I change my display unit to millions it will change my line as well.
Please take a look at my SS.
Solved! Go to Solution.
Hi @Yuiitsu ,
You could set unit in line and clustered column chart like below(you need to make sure you set this in Y-axis(column))
In addition , you said that "When I change my display unit to millions it will change my line as well", which part change? Please inform me in details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Yuiitsu ,
Did you enable secondary axis?
Then slip Scroll Bar in this list, you should see it . What is your desktop version?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Yuiitsu ,
You could set unit in line and clustered column chart like below(you need to make sure you set this in Y-axis(column))
In addition , you said that "When I change my display unit to millions it will change my line as well", which part change? Please inform me in details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
I did not thought of changing the display unit in Y-axis.
I changed in "Data Label" and this is what happened:
Hi @Yuiitsu ,
Yes, when you change unit in "Data Label", it will aplly to both line and column, this is by design. So I suggest you could change this in Y-axis, which should work.
In addition, you could change line unit in Y-axis(you will see in it Y-axis(line))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have checked afew times, but I do not have Y-Axis(line) ....
Any idea why?
Hi @Yuiitsu ,
Did you use "Line and clustered column chart"? If so, when you add field in column and line, you could click Y-axis
Then when Y axis expand, you could slip Scroll Bar, then you will see it(because it have two y-axis, you could set them separately)
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Its definately line and clustered column chart. But definately no Y-axis(line)
Could you think of any reason why? =(
Hi @Yuiitsu ,
Did you enable secondary axis?
Then slip Scroll Bar in this list, you should see it . What is your desktop version?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did not click show secondary. Now I am able to do it.
Thank you for your patience in helping me thank you very much!!
I was actually checking into this earlier today on a different thread. I cannot find any way that you can independently control the data labels between columns and line.
Thank you for confirming!