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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Nietzsche
Helper IV
Helper IV

why is my column chart showing percentage of number?

hi everybody,

 

using the Adventureworks dataset, with the exact field as the matrix shown below left, the column chart is not number, but they are all 100%. 

 

Do you know how to change from % to the actual saleAmount?

 

Nietzsche_0-1717765849782.png

 

1 ACCEPTED SOLUTION
rajendraongole1
Community Champion
Community Champion

Hi @Nietzsche -I think you have choosen the 100% stacked column chart, can you please change to Stacked column chart in green and check your values?

add , product category to X axis and sales amount is on Y axis.

 

rajendraongole1_0-1717769769064.png

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

1 REPLY 1
rajendraongole1
Community Champion
Community Champion

Hi @Nietzsche -I think you have choosen the 100% stacked column chart, can you please change to Stacked column chart in green and check your values?

add , product category to X axis and sales amount is on Y axis.

 

rajendraongole1_0-1717769769064.png

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.