Solved: Creating a Matrix Table from Different Columns

emman_burgonia · ‎09-16-2022

Hi everyone,

I am still pretty new in Power BI but I am having trouble creating a matrix visualization based on this table:

The idea should look like this

I was able to extract the years however I cannot add the count of codes for the columns. Can you help me figure out the possible solution for this?

Coriel-11 · ‎09-16-2022

In the "Rows" box drag the "Geocity" field

In the "Columns" box put the "EnrolementYear" field

In the "Values" box put the "Code" BUT then right click on it and choose "Count".

Apologies if that's what you've already tried. If so, perhaps you could explain a little more or provide some sample data.

Coriel-11 · ‎09-16-2022

In the "Rows" box drag the "Geocity" field

In the "Columns" box put the "EnrolementYear" field

In the "Values" box put the "Code" BUT then right click on it and choose "Count".

Apologies if that's what you've already tried. If so, perhaps you could explain a little more or provide some sample data.

emman_burgonia · ‎09-16-2022

Here's the sample data

CodeGeoCityEnrolmentYear

JorgePinho · ‎09-16-2022

If you want to display the number of codes by city and year you can do this:

Add the year field to the Columns and the city field in the Rows. Then in the Values you can add DAX measure like this:

Count_of_code = COUNTROWS(Code)

PijushRoy · ‎09-16-2022

Please share (copy and paste) sample data

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

Creating a Matrix Table from Different Columns