Matrix View issue

[learner03]

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 

[Anonymous · Accepted solution]

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]

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]

@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]

Like this ?

[learner03]

@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)-