Show overview in Matrix

[rasmus22]

Hi.

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.

Thanks

[amitchandak]

@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

[rasmus22]

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

Thanks