Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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.
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.
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 |
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)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |