Forum Discussion
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 th...
tex628
Community Champion
Community ChampionI 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?
Great, thanks.
They need to be a % of the total number of appointments (which are filtered out of this view).
- tex628
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?Yeah,
Rows: Appointment date (month)
Columns: Attendance status
Values: Count rows (named specifically for what I'm doing)