Data label Display Unit

[Yuiitsu]

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.

[dax · Accepted 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.

[dax · Accepted 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.

[Yuiitsu]

@dax 

Just another question, If I want to change the Display unit for Line where do I do it?

[Yuiitsu]

Thank you!

I did not thought of changing the display unit in Y-axis.

I changed in "Data Label" and this is what happened:

[dax]

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.

[Yuiitsu]

I have checked afew times, but I do not have Y-Axis(line) ....

Any idea why?

[dax]

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.

[Yuiitsu]

Its definately line and clustered column chart. But definately no Y-axis(line)

Could you think of any reason why? =(

[dax · Accepted solution]

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.

[Yuiitsu]

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

[Greg_Deckler]

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.

[Yuiitsu]

Thank you for confirming!