Forum Discussion
Creating a Matrix Table from Different Columns
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?
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.
4 Replies
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.
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)
Hi PijushRoy
Here's the sample data
CodeGeoCityEnrolmentYear
fr109 Rennes 2003-2004 fi016 Tampere 2019-2020 fi017 Helsinki 2021-2022 fi212 Espoo 2021-2022 fi033 Helsinki 0 fi034 Helsinki 2021-2022 fi036 Helsinki 2021-2022 fi041 Kuopio 2021-2022 bo008 Santa Cruz 2021-2022 bo008 Santa Cruz 2021-2022 bo008 Santa Cruz 2021-2022 bo008 Santa Cruz 2021-2022 at034 Vienna 2021-2022 ar103 Buenos Aires 2019-2020 ar103 Buenos Aires 2019-2020 ar103 Buenos Aires 2019-2020 ar103 Buenos Aires 2019-2020
