Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

Matrix Visual and visualization

I have a table called ProdInvc which has columns as product name, origin state, destination state, Quantity and amount. and another table which is just State that has State name. I need to make a mat...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi learner03 
    To get the desired result you should unpivot the states columns with Power query.

    Then you can create a matrix like this:

    Pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi learner03 
To get the desired result you should unpivot the states columns with Power query.

Then you can create a matrix like this:

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • learner03's avatar
    learner03
    Icon for Post Partisan rankPost Partisan
    2 years ago

    Ritaf1983 Thanks. How can I do conditional highlight based on each row by product in this situation like, if Max quantity in the row in destination belongs to same state and max quantity belong to state in origin then do not highlight otherwise highlight both max in both (destintion & origin)

    example-  max of product A is 1000 which belongs to y1 and max in origin is 1000which belongs to y1 so no highlight. Same for product B.

    But for product C, Max in the destination is 1000 which belongs to x1 and max in origin is 1000 that belongs to Z1, so highlight both values here. 

    In G, Max in destination  belongs to z1 which is 300 and max in origin belongs to y1 which is 343, so highlight both.