Forum Discussion
JurajSiska
7 years agoFrequent Visitor
percentage from total
Hi, I've imported some data from excel and created a quick table in Power BI How can I create a measure that calculates the percentage of the budget by each mean from the total? Tha...
- 7 years ago
This has actually helped. Now resolved.
JurajSiska
7 years agoFrequent Visitor
l've actually been splitting these number further by year and wanted to see a proprtional development YoY - to do this I used Show value as -> Percent of Column Total. This did the trick in the table.
Now, as 2019 has only just begun I cannot compare on the grand total with 2018 for the obvious reasons, but I still can compare how much budget goes to each mean proportionally. And I'd love to do this in a line chart (i.e. see development of Incentive going from 90% in 2018 to 60% in 2019), but there I cannot add the budget field second time, and show value as only offers Percent of Grand total, which again does not show what I need to see.
Am I being clear?
JurajSiska
7 years agoFrequent Visitor
This has actually helped. Now resolved.