Forum Discussion

learner03's avatar
learner03
Post 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 value even if a date has 3 or 4 Shipment # values.. I tried to achive this in table view but the dates are repeating. For instance, if a date has 3 values, then the date repeats 3 times.

Secondly I need to have functionality to show how much a SHipment# is receited in respect to the quantity shipped.

So, if on Dock 4, SHIP4031 has total shipped qty as 18,867 and it is in the process of receiting, then whatever they have receipted, it show shade the cell or give a small horizontal bar graph near it or anything related.https://drive.google.com/file/d/1nHTHKgT6rgNxGQLoi74_YEDmpMlL0ZYI/view?usp=sharing 

 

 

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

5 Replies

  • lbendlin's avatar
    lbendlin
    Super 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
      Post 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-

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    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