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, 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. 

😞