Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Matrix Subtotals as Percentage of total count

Greetings, I have a list of names with that were all polled on 4 specific dates (there will be more, but 4 for now)  I would like to get a listing of percentage of each type of response over the 4 dates.  I'm easily able to see this using a pie chart (each count is shown as a numeric count, and as a percentage of the total count).  I'm trying to find a way to show percentage of each response type to total responses in a matrix.  The rows are the names in the group, and the columns are the different responses.  I'd like for the matrix to show percentage of the subtotal for each response in the column.  I'm sure that there's a way, but I'm having a hard time finding it.

Super User
Super User
Frequent Visitor

Thanks Amit!  That's exactly the solution I was looking for!

Super User
Super User

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors