Forum Discussion
Helper IHow to create a %'s Stacked column chart based on another column total
I have this set of data. I want to get a chart with 2 columns: I do not kwnos how to get the column with the %'s of the different expenses related to the total revenues. Can you help me with this?
Thanks
Alvarom1 , Take Tipo on X-Axis, Revenue as Legend, Amount measure as values
And then have % like
Divide([Amount], calculate ([Amount], removefilters(Table[Revenue]) ) )
With new Label enhancement, use this % measure as Label details
New Power BI Data Label Customizations (December 2023) - Enhance Your Data Analysis & Reporting:
https://www.youtube.com/watch?v=qe3eW4OkAN8&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
1 Reply
- amitchandak
Super User
Alvarom1 , Take Tipo on X-Axis, Revenue as Legend, Amount measure as values
And then have % like
Divide([Amount], calculate ([Amount], removefilters(Table[Revenue]) ) )
With new Label enhancement, use this % measure as Label details
New Power BI Data Label Customizations (December 2023) - Enhance Your Data Analysis & Reporting:
https://www.youtube.com/watch?v=qe3eW4OkAN8&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L