Add percentage column to table visual

[luisadavidson]

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!

[tex628]

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? 

[luisadavidson]

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? 

[luisadavidson]

Yeah,

Rows: Appointment date (month)

Columns: Attendance status

Values: Count rows (named specifically for what I'm doing)