Alternative to using filters pane?

[Mclovin100]

Hello,

I have a matrix that im filtering using the filters pane. I had it hidden before but now users would like to filter so I showed the filters pane but now I have an issue with a certian visual that was filtered to only few rows  that contains "NewCost" word inside them and it should stay that way.

Is it possible that I can create a measure or a table that will do exactly like what the filter pane is doing without needing the use the filters?

Thanks!

[v-yadongf-msft · Accepted solution]

Hi @Mclovin100 ,

This is my test table:

Create a measure:

Measure = IF(CONTAINSSTRINGEXACT(MAX('Table'[Word]),"NewCost"),MAX('Table'[Word]))

Create a visual:

The result are rows that contain "NewCost" word inside them.

Best regards,

Yadong Fang

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

[djurecicK2]

Hi @Mclovin100 ,

 First, nice user name 😀

Second, you can use slicers as an alternative to the filter pane. You can have more control over how a slicer works.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-deskt...

Please accept as solution if this answers the question- thanks!