In this power bi tutorial, we will see power bi slicer multiple selections. And also we will see the below points:
- Power bi slicer multiple selection
- How to allow multiple selection in Power bi slicer
- Power bi slicer multi select without ctrl
- Power bi slicer to select multiple measure
- Power bi slicer multi select not working
- Power bi slicer disable multiple selection
- Enlighten slicer power bi multiple selection
Power bi slicer allow multiple selection
Here we will see power bi slicer allows multiple selections in the power bi desktop.
- Open Power bi desktop. Load the data using get data
- In power bi desktop, select the slicer from the visualization.
- In the Field, drag and drop the EnglishProductName from the field pane.
- Click on the Formatting section in visualization pane.
- Expand the selection control, Turn off the Single select.
- When you turn off the single select, the multiple select and select all you can activate.
- Turn on the Multi-select with ctrl, you can select the multiple values by pressing the Ctrl.
- If you turn off the Multiple select with ctrl, then you can select the multiple values without pressing any ctrl key.
In the below screenshot you can see the power bi slicer multiple selections.
Power bi slicer multiple selection
Here we will see Power bi slicer multiple selections in the power bi desktop.
- In power bi desktop, select a slicer from the visualization.
- In the Field, drag and drop the EnglishProductName from the field pane
- By default we can select the single value.
- To select multiple value, press the Ctrl + select the values.
Read Power bi slicer multiple columns with examples
Power bi slicer multi select without ctrl
Here we will see power bi slicer multi select without ctrl in power bi desktop.
- In power bi desktop, select the slicer from the visualization.
- In the Field, drag and drop the EnglishProductName from the field pane.
- Go to Formatting section, in the visualization pane.
- Expand the selection control.
- Turn off the single selection.
- Then turn off the multi select with ctrl.
- Now you can select the multiple value in the power bi slicer.
- In the below screenshot, you can see the power bi slicer multi select without ctrl.
Read Power bi show value as percentage
Power bi slicer to select multiple measures
Here we will see a power bi slicer to select multiple measures in the power bi desktop.
For this, I have created two tables in Power BI, in one table I have added group index and sales, and other tables I have added one column which we will use as a slicer.
Table 1
Table 2
- Now i will create three measure. For that click on New measure in the ribbon in power bi desktop.
- The measure 1 is:
Measure 1 = IF("A" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Index])))
- In similar way create measure 2 and measure 3.
- The Measure 2 is:
Measure 2 = IF("B" IN VALUES('Y axis 1'[Measurement 1]),CALCULATE(SUM(Table1[Sales])))
- And the measure 3 is:
Measure 3 = IF("C" IN VALUES('Y axis 1'[Measurement 1]), CALCULATE(SUM(Table1[Sales]),ALL(Table1)))
- Once you created the measure, click on slicer from the visualization.
- Then in the Field, drag and drop the Measurement 1 from the Y-axis.
- Go to the formatting section in the visualization pane, Expand the selection control.
- Turn off the single select. And turn on the Multi select with Ctrl.
- Now you can select multiple measures, by clicking on the ctrl.
- In the below screenshot, you can see the power bi slicer to select multiple measure.
Read Power bi calculated column vs measure
Power bi slicer multi select not working
Here we will see power bi slicer multi-select not working in power bi.
To solve this problem:
- Select the slicer in the canvas.
- Go to formatting section in the visualization pane
- Expand the Selection Control.
- Then turn off the single selection.
- Turn on the Multi select with Ctrl.
- Now you can select multiple values in the power bi slicer by pressing the Ctrl.
- In the below screenshot you can see the multi select values.
Power bi slicer disable multiple selection
Here we will see power bi slicer disable multiple selections in the power bi desktop.
- Select the slicer from the power bi report.
- Go to formatting section under visualization
- Expand the Selection control, turn on the single selection, which will turn off the multi select with ctrl.
Now you can select the single value from the power bi slicer.
Enlighten slicer power bi multiple selection
Here we will see enlighten slicer power bi multiple selections in power bi desktop
We will first enlighten the slicer custom visualization to make choices look like a navbar. Then we enable the multiple selections, to select multiple values in the power bi slicer.
- In Power bi desktop, select the slicer from the visualization.
- In the Field, drag and drop the fiscal year from the field pane.
- Click on the Formatting pane, then expand the General.
- Under Orientation, select Horizontal.
- Now we will enable the multiple selection in power bi slicer.
- Click on the formatting section in the visualization pane, expand the selection control.
- Turn off the single select, and Turn on the Multi select with ctrl.
- Now you can select multiple values from the power bi slicer by clicking on the Ctrl.
- In the below screenshot, you can see the enlighten slicer power bi multiple selection.
You may like the following Power BI tutorials:
- How to set default value in Power BI Slicer
- Power bi slicer panel – How to use
- Power bi slicer filter another slicer – How to do
- Power bi treemap – How to use
- Power BI Slicer Search Box
In this power bi tutorial, we learned power bi slicer multiple selections. And also we will discuss the below points:
- Power bi slicer multiple selection
- Power bi slicer allow multiple selection
- Power bi slicer multi select without ctrl
- Power bi slicer to select multiple measure
- Power bi slicer multi select not working
- Power bi slicer disable multiple selection
- Enlighten slicer power bi multiple selection
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com