Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional filtering between charts

Hi Colleagues, I have an issue with filtering. So i have 2 graph, first  graph has YEARMONTH on the X line, the second is a Pie chart, which has not YEARMONTH dimension,therefore on the Pia chart i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create measures and a column.

    measure_ = SELECTEDVALUE('Table'[date])
    Column = IF('Table'[Year]=MAX('Table'[Year]),'Table'[VALUE],BLANK())
    Measure_2 =
VAR _maxyear =
    MAX ( 'Table'[Year] )
VAR maxyaevalue =
    IF ( MAX ( 'Table'[Year] ) = _maxyear, MAX ( 'Table'[VALUE] ), 0 )
RETURN
    IF (
        MAX ( 'Table'[date] ) = [measure_],
        MAX ( 'Table'[VALUE] ),
        SUM ( 'Table'[Column] )
    )

     Then Click the bar chart>>Format>>Edit interactions. Then choose filter on pie chart.

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please refer to my pbix file to see if it helps you.

Create measures and a column.

measure_ = SELECTEDVALUE('Table'[date])
Column = IF('Table'[Year]=MAX('Table'[Year]),'Table'[VALUE],BLANK())
Measure_2 =
VAR _maxyear =
    MAX ( 'Table'[Year] )
VAR maxyaevalue =
    IF ( MAX ( 'Table'[Year] ) = _maxyear, MAX ( 'Table'[VALUE] ), 0 )
RETURN
    IF (
        MAX ( 'Table'[date] ) = [measure_],
        MAX ( 'Table'[VALUE] ),
        SUM ( 'Table'[Column] )
    )

 Then Click the bar chart>>Format>>Edit interactions. Then choose filter on pie chart.

 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.