Power BI Tutorials for Beginners: Part 6
This is Part 6 of the article which deal with Slicer in Power BI
What is a Slicer Visualization?
Slicer as the name suggest would slice the data that means it will apply filters to the data elements or the charts or visualization.
Let’s use Slicer Visual to understand what it does:
I have selected Slicer from Visualization tool and from the table PBI_DIY_BDCS_Sales the Customer Country column has been selected as shown below
Now when I select the checkbox of country India the other visualization used will be affected and only the data of India is available as shown below
Also there are different types of slicers, In our condition there are only two types as List and Dropdown as shown below
Note: We can have more different types of Slicer.
The default type was List, then I selected Dropdown and see the changes shown below
It shows all country present in data of Customer Country column.
Now when I select one country (US) it will affect other visualization and the data of US will be available.
Now the problem here is we are able to select only one checkbox(country) at a time, but we want to select multiple checkbox at once.
So for that we need to make some changes in properties.
Go to Format -> Selection Controls -> keep the Multi-select with CTRL as ‘ON’ as shown below
After the above step, we can now select multiple checkbox (country) and see the changes of other visualization as well
Note: We can enable single select (which is default), Select ALL options as well like how we did for Multi-Select with CTRL option.
We can enable Select ALL and Multi-Select with CTRL option at a time
Get Arjun Sharma’s stories in your inbox
Join Medium for free to get updates from this writer.
Let’s understand the above statement in Note
When I enabled Single Select option, the Multi-Select with CTRL and Select All option disappears
When I kept off the Single Select option then both the Multi-Select and Select All option is visible.
As I have kept ON the Select ALL option, a checkbox of Select All option will be visible in Slicer.
Click on Select All checkbox and we will get to see the data of all the countries on other visualization as well.
Now as I select various options as Select All, Single select, Multi-Select(country) in Slicer the other visualization gets affected.
I want one of these Visualization should not get affected when I select various options in Slicer.
To do that we have to use the “Edit Interactions” option in the Format and select the Visualization that you want need not get to be affected by clicking on None as shown below.
Note: After clicking on Edit Interaction option select on Slicer icon.
From Slicer select the checkbox (country) and see whether the changes are happening on Visualization in which we have enabled None.
When I selected the checkbox of India, all other visualization got affected but not the one which I enabled None as shown above.
With the following PowerBI video knowing extensively will always be help to avail more opportunities: -
