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 th...
luisadavidson
7 years agoFrequent Visitor
Great, thanks.
They need to be a % of the total number of appointments (which are filtered out of this view).
tex628
Community Champion
7 years agoIt should be easy to do.
Your visual, is it a matrix with appointment status as the column dimension and a countrows() as the value?
- luisadavidson7 years agoFrequent Visitor
Yeah,
Rows: Appointment date (month)
Columns: Attendance status
Values: Count rows (named specifically for what I'm doing)