Showing results for 
Search instead for 
Did you mean: 
New Member

Show overview in Matrix


I am new to Power Bi and trying to learn it.

My problem is:

I want to make a matrix which shows all the projects in realation to the phase.

I have a spreet sheet with project names and phase for the induvidual projects.


I have attached a picture of what i am thinking.


Colors and other design can be added afterwords.




Super User
Super User

@rasmus22 , based on what I got.

Create a rank column

rank = rankx(filter(Table, [Phase] = earlier([Phase]) ), Table[Project])


In matrix visual take  Phase on column, Rank on row, and max of project on values

Thank you for your reply.

I think it is my missing skills for this. I am new to Power BI and not a programmer.

I have posted below what i want to do.


I have one table with data as shown. From this table i want to make a scorecard. Both tabel and scorecard is showed below.

The scorecard should be updated with a tile or card in a matrix, as below.

The name should be in the tile or card under the correct phase. The tile or card with the highest price should be higest in the correct phase.

As an extra i need to be able to filter for department, so only the the chosen department will be present in the scorecard.


G1, G2, ... G5 is just visual info





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.

Top Solution Authors