Automatically adjust formatting of the y axis (% vs M)

[Anonymous]

Hello everyone!

I have a page with a chart that allows the user to change the value of the columns (the line is a measure that calculates the difference to the base value). The values that the column can take includes both absolute values (millions) and percentages. Is there a way to make the formatting dynamic? Meaning that the format of the y axis labels change to % when the value is between 0 and 1 for example?

Note: I can not change the format in the data ta ble that the chart feed from since it is unpivoted and all the values are in one column, which means its got to have only one format.

Thanks for any input, I really appreciate it!

Best,

Rasul Kireev

[v-juanli-msft]

Hi @Anonymous 

Could you show an example data for analysis?

I test with the following data, but can't reproduce your problem.

PS:

for this question,

"Note: I can not change the format in the data ta ble that the chart feed from since it is unpivoted and all the values are in one column, which means its got to have only one format."

your understanding is correct, one column can't have two kinds of format at the same time.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

So as you can see in the picture above I have a "Unpivoted" table with repeating values for Option and Attribute, but a combination of each is unique and has a uniqie value. What I want is for all the Absolute values  (e.g. Net Written Premium, Cede Loss) to stay as they are, but for the 0 to 1 values (e.g Ceded LR, Combined Ratio, etc) to display on the graph as percents.

Thanks a lot for your help!

[v-juanli-msft]

Hi @Anonymous 

We can use "FORMAT" funtion to have two data format in one measure.

But it change the measure to type Text instead of number.

this only makes changes to the measure (data label) instead of the y axis label.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.