Forum Discussion
Showing total in a table
Dear all, good morning. I have the below table and would like to create a chart that would showcase the total of cargoes by day. Cargo ID Entered Day Released Date A 01/01/2021 03/...
Hi again Pedro !
I have updated the example
There is a By Mate page and By Month page.
Click on day or month on the graph and all the valid cargo details will be displayed in the bottom visual.
This is done by adding the Valid Cargos field in the filter panel
See attached screen print
please click thumbs up and accept solution, thank you.
speedramps
Super User
Super UserAs explained before, this measure will handle by day, month with a calendar
Valid cargos =
var min_date = MIN ( 'Calendar'[Date] )
Var max_date = MAX ( 'Calendar'[Date] )
VAR validrows = FILTER ( Commodity_List , Commodity_List[Entered Day] <= max_date && Commodity_List[Released Date] >= min_date )
RETURN
COUNTROWS ( validrows )
But how can I see which cargoes are being considered for each date? I would like to click on the chart and show me on a table what are the ones considered (like cargo A,B for day2)