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 for the induvidual projects.

 

I have attached a picture of what i am thinking.

 

Colors and other design can be added afterwords.

 

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super 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