Changing Y axis and label format to "%" depending on another value

[federicoBCV]

Hi,
I am working with a graph whose values (Y-axis and labels) should be shown either in a percentage format or in decimals. Another column of a related table has the value "percentage" when the values should be in a % format. Is there any way to automate that?

Thanks,

[v-stephen-msft]

Hi @federicoBCV ,

You need to set up the field in Y-axis of your visual.

Below is an example, click "%" for the field in Y-axis and the field will change to a percentage.

Best Regards,

Stephen Tao

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

[federicoBCV]

Hi, Stephen,

The problem is that not all the values of the field must be changed to percentage. Just a few of them, when another field indicates that. 

Thanks 

[v-stephen-msft]

Hi @federicoBCV ,

I understand what you mean, but for now, you can try creating a visual with a second y-axis.

For example, the line and stacked column chart or the line chart.

Best Regards,

Stephen Tao

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