Forum Discussion
How to get percentage from multiple different rows
Hi
I have 4 different column values that come from table. Each value must be Sum and percentage and last one total of them all
Below is example where 101 = sum(tablename.column2) is 100% and then 33 = sum(tablename.column3) is 32%, 23 is 22% and so on
With these values i need to make a graph. Do i need to write some kind of measure, where it would take 4 different sum values of then change them to needed percentage or is there another way?
4 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Depends on what you want your graph to be, can you provide an example?
I dont really have a specific graph in mind. As long as it shows the right percentage. I tried with stacked column graph
Test file:
https://www.upload.ee/files/10390008/Test.xlsx.html
JanCurrentAmount is the total and current, totaloverdue, indispute, incollection are then part of it.
- v-diye-msft
Community Support
Hi Anonymous ,
we've got your file but not quite understand your requirement, could you please show me your logic and expected data?
