Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
2 years ago
Solved

Formatting a matrix

Hello, Need your kind support in the following scenario I have a matrix view with the following: Rows: Customer Project   Columns: Quarter Date   Value: Sum   in Column Date, there is...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I tried not to alter the relationship or create new dimension tables in your semantic model. I suggest to try to create relationships with having new dimension tables.
    But for now, please check the below picture and the attached pbix file whether it suits your requirement.

     

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi, Please check the picture down below.

    Thank you.

     

     

abukapsoun's avatar
abukapsoun
Post Patron
2 years ago

My table has some other columns as well, however I am not using them in this specific matrix. Could it be the reason?