Skip to main content

Power BI

Needs Votes

AND Slicer - OR Slicer - Measure Slicer

Vote (31) Share
Matthew P.'s profile image

Matthew P. on 19 Oct 2017 11:44:37

Hi guys,

First of all, well done! Great tool for data visualisation.

Going through lots of data analysis with big data, I was in need of a special slicers.
The slicer you have at the moment only allows to OR the selections. But there have been many times that I needed AND slicers to actually AND the selections.

Also I really needed to use slicers on measures.

Comments (3)
Matthew P.'s profile image Profile Picture

Christer Karlsson on 05 Jul 2020 23:48:15

RE: AND Slicer - OR Slicer - Measure Slicer

I have struggled with AND in several cases. A simple example is a customer listing where you want to filter out all customers in common cities. In this example you would select the cities in one slicer and the result would be all customers doing business in the selected cities -> AND. Consequently the customer list gets shorter as you select additional cities.

Currently when you select cities the company listing gets longer as you click additional citis -> OR.

Matthew P.'s profile image Profile Picture

David on 05 Jul 2020 23:29:29

RE: AND Slicer - OR Slicer - Measure Slicer

If you use multiple slicers, it will AND each one. You can have multiple slicers on the same target if you need to AND the same source for some reason.

Matthew P.'s profile image Profile Picture

Ninu on 05 Jul 2020 23:12:27

RE: AND Slicer - OR Slicer - Measure Slicer

It would be really helpful to have slicers on measures