Dax filter

Question

I have a matrix with a row hierarchy comprising Name, Year and Month. Year is filtered to 2019.

I also have an area chart plotting the values from the matrix.

When selecting a Name from the matrix, is it possible to make my area chart show values for all years rather than the matrix filter of 2019?

anonymous · Answer

Turn off interaction between two visuals.ThanksPravin

anonymous · Answer

Thanks&nbsp;Anonymous,&nbsp;however that would stop the Name filter to my area chart also.&nbsp;Basically I want the area chart to ignore the 2019 filter that is set on the matrix but whilst also filtering on Name.&nbsp;

greg_deckler · Answer

You could use ALLEXCEPT in your measure and remove the Year filter.&nbsp;&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Forum Discussion

Dax filter

3 Replies

Related content

DAX FILTER with multiple criteria

DAX MEASURE TO FILTER

Dax

DAX Formula Help

Dinamic dax with filters