PowerBI Counting multiple values in a column

Question

Data source

Column A         Column B

Bill             Fly
Bob              Drive
Tom              Walk
Dave             Fly
Dave             Walk
Bill             Drive
Tom              Drive

There will be 8-10 entities in Column A and 3 different values in column B and a total of 200-300 rows. I need to create a visualization (a table, matrix, or multi-row card is what I am thinking) That will show the count of each column 3 value for each entity. So that it would display as

         Fly    xx
Bill     Walk   xx
         Drive  xx

         Fly    xx
Tom      Walk   xx
         Drive  xx

Anyone know how I could accomplish this and have it display as above (the Column A entity only listed once with the 3 column B values to the right)?

You may want to try to more clearly show the inputs and outputs that you are using. It's not clear at all what you are trying to do. — Jarrod
Thank you for that. The examples of the names and activities displayed differently when I typed the question. I will try to edit and make it more clear — Juiceman9255

Powerbi Powerbi · Accepted Answer · 2021-02-20T08:28:30

Can you check Stepped-layout option in the matrix?

PowerBI Counting multiple values in a column

1 Answers