Show in Chart decimal and percentage

[Laura7]

Hello,

I was wondering if I can display percent and decimal in a line and stacked column chart on the secondary y-line. In excel it would look like this: 

Unfortunately, it doesn't look like that at all in Power Bi:

This is my line only with the percentage value. if I connect both I don't get a reasonable view

I am still very new to Power Bi, so I don't know if it works and if so how.

Can someone perhaps help me?

Kind regards,

Laura

[lbendlin · Accepted solution]

You are trying to do too much.  Is this a business requirement or something you came up with yourself?

For charts with more than two Y axes you would need to use custom visuals, and make sure your report users understand what they are looking at.

[Laura7]

Hi,

first thanks @v-junyant-msft for your help. it's not quite what i was looking for, but it's really useful knowledge that i'm sure i'll need, so thank you very much. My problem is rather that the first value is a decimal number. The other value is a percentage where the customer would like to have a scale from 0 - 100% but also wants the second line to be exactly the same as before. 
And @lbendlin this is unfortunately a business requirement how can i build such a custom visual?

[lbendlin]

Use the Deneb visual.

[v-junyant-msft · Accepted solution]

Hi @Laura7 ,

@lbendlin Thanks for your concern about this case!
And @Laura7 , the reason for this very wide separation of the top and bottom lines and one line almost entirely close to the x-axis is that your two folds are sharing an x-axis, and the one above you has a value of hundreds to thousands, while the one below has a value of less than one.

If you want your visual objects to look good, you can try this button:

After opening:

You can see the two folding lines more clearly

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

You are trying to do too much.  Is this a business requirement or something you came up with yourself?

For charts with more than two Y axes you would need to use custom visuals, and make sure your report users understand what they are looking at.