Data label Display Unit

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

Need Help

Show and Tell

Tips and Tricks

Tutorial Requests

dax
6 years ago
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.
dax
6 years ago
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.

dax

Community Support

6 years ago

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.