Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MachisukiJ
Helper I
Helper I

Percentage

MachisukiJ_1-1679060427173.png

Good morning to everybody, i was wondering around if there's a way that i can make these 3 collumns turn out into 1 and turn that result into an percentage, like that example here 

MachisukiJ_2-1679060551954.png

i tried using some of the solutions that i've had found here but none of them worked, most of them make the result be something like 3800%, since now im gratefull for your help.

1 ACCEPTED SOLUTION
marcl1
Helper II
Helper II

unpivot in query editor
divide by 100
change the format to %

View solution in original post

1 REPLY 1
marcl1
Helper II
Helper II

unpivot in query editor
divide by 100
change the format to %

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.