Forum Discussion

PetrS's avatar
PetrS
Frequent Visitor
4 years ago
Solved

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 s...
Need Help
  • v-kelly-msft's avatar
    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!

Greg_Deckler's avatar
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's avatar
    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's avatar
      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!

      • PetrS's avatar
        PetrS
        Frequent Visitor
        4 years ago

        It works, thank you a lot.