Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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?
Great, thanks.
They need to be a % of the total number of appointments (which are filtered out of this view).
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |