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.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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.

 

 

abukapsoun's avatar
abukapsoun
Post Patron
2 years ago

Thank you once again for the effort! The formula was accepted by DAX. But when I am putting it as a conditional formatting as suggest, I got the below error:

 

Despite of MatchBy columns being specified, duplicated rows are encountered in OFFSET's relation parameter. This is not allowed

Is there a way maybe we can use other than OFFSET?

 

Thank you!