Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure created with FILTER in line chart does not filter table

I have a line chart that is plotting 3 measures.   Each measure is filtered based on "Type" in the underlying data set.

 

  • MeasureA = DIVIDE(CALCULATE(DISTINCTCOUNT('CloseTable'[Logo]),filter('CloseTable','CloseTable'[Type]="A")),CALCULATE(DISTINCTCOUNT('AllTable'[Logo]),filter('AllTable','AllTable'[Type]="A")))
  • MeasureB = DIVIDE(CALCULATE(DISTINCTCOUNT('CloseTable'[Logo]),filter('CloseTable','CloseTable'[Type]="B")),CALCULATE(DISTINCTCOUNT('AllTable'[Logo]),filter('AllTable','AllTable'[Type]="B")))
  • MeasureC = DIVIDE(CALCULATE(DISTINCTCOUNT('CloseTable'[Logo]),filter('CloseTable','CloseTable'[Type]="C")),CALCULATE(DISTINCTCOUNT('AllTable'[Logo]),filter('AllTable','AllTable'[Type]="C")))

Under the line chart I have a table with columns from the CloseTable dataset.   My expected result is to have the table filtered by Type when I click on a data point in the line chart.   Right now, no filtering in the table occurrs when I interact with the line chart.  Interactions are set between line chart and table.

 

Is it possible to filter another visual based on the filters contained in a measure?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    Visual interaction is based on fields that aggregated in current row contents. When you activate a chart, power bi will try to find out the current category data label and use it to interact with other visuals through current relationship key field.

    Did these tables contain relationships? If not, power bi can't interact with other visuals based on the current chart data category label.

    Regards,

    Xiaoxin Sheng