Line chart and Date selection

Hi all

I have a source with three columns: Date, Location, Quantity. I would like to do visual with table: Location, Quantity and Line chart: Date, Quantity. It is done, it is easy. But if I don't select a one date on Line chart, Table shows sum of quatities over all days and it is wrong. Is possible to see Line chart for all days and Table for the one -selected- day.
1. Default - automaticaly the select last day in the Line chart after open.
2. Allow to show quantity only for one day everytime in Table (based on the selection in Line chart)

Thank you for help

Need Help

v-kelly-msft

4 years ago

Hi PetrS ，

Create 2 measures as below:

_quantity =
VAR _maxdate =
    CALCULATE ( MAX ( 'Table'[date] ), ALL ( 'Table' ) )
RETURN
    IF (
        ISFILTERED ( 'Table'[date] ),
        SUM ( 'Table'[quantity] ),
        CALCULATE (
            SUM ( 'Table'[quantity] ),
            FILTER (
                'Table',
                'Table'[date] = _maxdate
                    && 'Table'[location] = MAX ( 'Table'[location] )
            )
        )
    )

_quantitytotal = SUMX(VALUES('Table'[location]),'Table'[_quantity])

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

Line chart and Date selection.pbix38 KB

6 Replies

Greg_Deckler
Community Champion
4 years ago
PetrS Would need sample data to be more specific but you can use Edit Interactions on the View menu to change the behavior of visuals interacting with one another.
- PetrS
  Frequent Visitor
  4 years ago
  
  data
  
  correct view ... if I choose a day
  
  without selection table shows sum
  I took some screenshots. I hope it helps. I need to see quantities in Table only for one day. I don't know ... update Table only if a one day is selected in Line chart or some conditions for Line chart selector. In the case of Stock time projection the sum is nonsense
  - v-kelly-msft
    Community Support
    4 years ago
    Hi PetrS ，
    
    Create 2 measures as below:
    
    _quantity = VAR _maxdate = CALCULATE ( MAX ( 'Table'[date] ), ALL ( 'Table' ) ) RETURN IF ( ISFILTERED ( 'Table'[date] ), SUM ( 'Table'[quantity] ), CALCULATE ( SUM ( 'Table'[quantity] ), FILTER ( 'Table', 'Table'[date] = _maxdate && 'Table'[location] = MAX ( 'Table'[location] ) ) ) )
    _quantitytotal = SUMX(VALUES('Table'[location]),'Table'[_quantity])
    
    And you will see:
    
    For the related .pbix file,pls see attached.
    
    Best Regards,
    Kelly
    
    Did I answer your question? Mark my reply as a solution!
    Line chart and Date selection.pbix38 KB
PetrS
Frequent Visitor
4 years ago
datacorrect view ... if I choose a daywithout selection table shows sum
I took some screenshots. I hope it helps. I need to see quantities in Table only for one day. I don't know ... update Table only if a one day is selected in Line chart or some conditions for Line chart selector. In the case of Stock time projection the sum is nonsense 😕