Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Show overview in Matrix

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , 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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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