Forum Discussion

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

Matrix View issue

I haved the pbix. I need below view with an additional feature. When I try to create below view in Matrix and put the Shipment # column in values, it gives first Shipment and displays just one valu...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  learner03 ,

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _shipped=CALCULATE(SUM('Sheet6'[Shipped QTY]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
var _received=CALCULATE(SUM('Sheet6'[Received Qty]),FILTER(ALL(Sheet6),'Sheet6'[Dock#]=MAX('Sheet6'[Dock#])&&'Sheet6'[Container #]=MAX('Sheet6'[Container #])))
return
_shipped+_received

    2. Result:

     

    Best Regards,

    Liu Yang

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Here's my proposal.  Matrix visuals aren't very good with conditional formatting. I used a Tooltip instead.

 

Note 1: I used the CONCAT field but made its column extra narrow. 

Note 2: Your requirement results in a single value per matrix row.  That's not what a matrix is for.

 

See attached for the pbix.

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
4 years ago

lbendlin I do not need the user to hover over a particular cell to see its data. I need something as a dashboard display to see what containers are at which dock and how  much they have been receipted till that moment.

So, is there any other way I can display this if matix isn't the best option?

Something like data about what containers-what are at which dock in matrix or table and below that another visual that shows dock and container in a graph form like they do in sales related to budget and tareget. In this scenerio, quantity shipped and receipted till now? visual something like below-

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Like this ?

     

     

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

      lbendlin yes, but what if there are more than one container at a dock, which is still a case in the dataset.

      So, can we have dock on x-axis as you displayed but one bar per container and it shows visual somewhat like this (all containers in one dock together)-