Forum Discussion
luisadavidson
7 years agoFrequent Visitor
Add percentage column to table visual
Hi all,
Sounds like a potentially simple request, but I have a matrix in PBI and I want to add % columns for each column, including the total column. Please could you advise the best way to do this? If I need to create a measure, do I create this in the report view or data view, or edit query mode? Thanks!
4 Replies
- tex628
Community Champion
I would do it as a measure in the report view.
But i would need to know exactly what you mean by percentage column if you want an example in code.
What should they be a % of?- luisadavidsonFrequent Visitor
Great, thanks.
They need to be a % of the total number of appointments (which are filtered out of this view).
- tex628
Community Champion
It should be easy to do.
Your visual, is it a matrix with appointment status as the column dimension and a countrows() as the value?