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.
@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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.