Visualization 03 columns for the same row

[Doris]

Hi guys,

Regarding the visualization in PowerBI i currently face an issue:

This is the data i have, suppose that its not connect to any other tables.

year   name     0%         100%        200%

2020     a       7.5%          7.1%          6.91%

2020     b       6.23%        6.15%        5.93%

now i want to have a chart with axis is the name, and show 03 columns with 0% 100% and 200%.

It seems to be easy but when i did so, Axis: Plant Name, those columns in Values than powerbi instead of just put those % do some calculations (sum- average-....) while i just simply want to show the % content which is already available.

I would really appreciate if anyone can help.

Thanks a lot!!

[v-lid-msft]

Hello @Doris,

We can change the type of the columns to meet your needs.

In the data view, change the column type to decimal number and set the percentage format.

Then we can do visual as follows.

If you don't meet your requirement, could you display the exact expected result based on the table you shared?

Best regards

[v-lid-msft · Accepted solution]

Hi @Doris ,

We can change the columns’ type to meet your requirement.

In the data view, change the columns’ type to decimal number and configure percentage format.

Then we can make visual as following.

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

[Doris]

@ v-lid-MSFT Well yes, it works by now. Thank you so much!