Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicers and filters on visualization

I am working on a report that has a slicer based on the field TE_GROUP and also a page filter on the same TE_GROUP field. When selecting a value in the Slicer and one on the page filter the visibile ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    By default power bi use 'AND' logic' to link different filters and you can't do custom with these effects.
    For your requirement, I'd like to suggest create a callout table with field value with relationship and write measure to use DAX expressions to compare and return flags, then you can use it on 'visual level filter' to achieve custom filter effects.

    Applying a measure filter in Power BI 
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Anonymous,

By default power bi use 'AND' logic' to link different filters and you can't do custom with these effects.
For your requirement, I'd like to suggest create a callout table with field value with relationship and write measure to use DAX expressions to compare and return flags, then you can use it on 'visual level filter' to achieve custom filter effects.

Applying a measure filter in Power BI 
Regards,

Xiaoxin Sheng