Hello Folks!
In this blog we are going to discuss about reverse slicer functionality in Microsoft Power BI
Slicers are the most used visuals in all of our reports. Whenever we want to make a selection, we simply choose value and our data is filtered accordingly, But have you ever tried playing it opposite way? Well, Let’s get started:
A: Look at the basic Data
B : Observe your Basic Filtering
Now Let’s play it opposite – On Selection Of State California – I shall not see California in Resulting Data So, Here we go
Step 1: Create a new table where you have all your Distinct States
Step 2: Create a Measure- as Exlcude_state
Step 3 : Replace Your Slicer By Col – StoreState which comes from table that we just created above – ReverseSlicer-State. And Filter your visual where you want to exclude your value as StoreState Value is n
And Here we reach our Final Result
Happy Learning!
Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S. Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com or Contact us.
Raksha Gangwal
Data Analyst
Addend Analytics