Forum Discussion
Is Advanced Filtering with logical operators across multiple columns possible in PBI Desktop?
I want to setup a filter that, for example, can filter rows where the date is greater than x and where the category is y or the location is z. In SQL it would be like: SELECT * FROM table as t WH...
The problem in my case is that I want to show a visualization of a table and I want the user to be able to change its filter dynamically, but the filter should works as follows:
(columnA > [slicerValue] && columnB > [slicerValue]) || (columnA = [slicerValue] && columnC = [slicerValue])
I want to be able to change slicerValue dynamically. Do you knwo how can I achive this?
Thanks in advance!
Use a disconnected table (or a parameter) for the slicer. Then use a measure that implements your logic. Use that measure as a filter on the visual.