Forum Discussion

KarthikKS's avatar
KarthikKS
Regular Visitor
3 years ago
Solved

Cascading filters in Filter Pane

Hello Everyone,   I've been so far using the slicers for this report but as a phase upgrade we thought to move the slicers to the filter pane, that's when we encountered the issue which we were abl...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi KarthikKS,

    In fact, current power bi use 'AND' logic to link different filters. So if you choose items on one filter, the other filter and visualizations which enabled interaction will be filter by current filter effects.

    If you want to achieve some customize selection effect between these filters, you can try to break relationships between these table and write measure to use Dax formula to filter slicer item based on selection and use on ‘visual level filter’ to filter records.

    Applying a measure filter in Power BI - SQLBI

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi KarthikKS,

In fact, current power bi use 'AND' logic to link different filters. So if you choose items on one filter, the other filter and visualizations which enabled interaction will be filter by current filter effects.

If you want to achieve some customize selection effect between these filters, you can try to break relationships between these table and write measure to use Dax formula to filter slicer item based on selection and use on ‘visual level filter’ to filter records.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng