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

Hi Jihwan_Kim 
Appreciating your support! I did't know how to attach the pbix here, so please find it with the following google drive link. 
instead of formatting the font color, it would be great if we do it as background color instead. 

if today value is bigger than previous value, then green background, and if small then red background. 

Thank you very much once again!

https://drive.google.com/file/d/1cPqkMiIHoidA6mUu9KRFuPte0zGRDNWx/view?usp=sharing

 

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!

  • abukapsoun's avatar
    abukapsoun
    Post Patron
    2 years ago

    I have added the other columns into PARTITIONBY and MATCHBY and now it is working like charm!! Thank you! 
    One last thing, how to apply the same on the Total row at the buttom of the matrix?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      2 years ago

      Hi, Please check the picture down below.

      Thank you.

       

       

      • abukapsoun's avatar
        abukapsoun
        Post Patron
        2 years ago

        Hi Jihwan_Kim 

        I still need your help please. I found out that in case some rows are available in earlier date, and not in later date or vice versa. formatting is happening randomly. I tried as much as possible to crack but in vain 😞

        If you don't mind I am sharing my full date, however I have renamed all field for data sensitivity matters. 

        https://drive.google.com/file/d/1kczK4cY1kw4mVrTXzkTie74HHhE-dLKR/view?usp=sharing

         

        for example in 2024Q2 row QOpg5ckTLFycbVD7kRdU0r2MGd, the later date is highlighted in green, while both have same values. 

        😞