Using Switch option, how to enable Multiple Selection working

[sagarsahoo_123]

Hi All,

Need your support to resolve one problem. I have a table  and i created a multiple option value in slicer using Switch function.

It is working fine if i select one filter at a time. But it is not working when multiple selection is done. How can i acheive multiple selection value to be displayed as per my selection. 

please find the below screenshot for single selection which is working fine as per expectation.

But when multiple selection is done, it is not working as expected.

It is showing Sum of FTE as value as it is selected in the table value.

Any help in this regard to resolve is highly appreciated. Kindly help.

Regards,

Sagar

[vs_7]

Hi @sagarsahoo_123 ,
Try out the Below steps

Here are the steps to enable multiple selections in a slicer:

1. Create a slicer: First, create a slicer visual on your report canvas.

2. Configure the slicer: In the slicer settings, you should have an option to allow multiple selections. Make sure to enable this option. Depending on the version of Power BI you are using, the option might be called "Single select" or "Multi-select."

3. Use the slicer: Now, users can select multiple items in the slicer simultaneously by holding down the Ctrl key (or Command key on Mac) while making selections.

4. Update visuals: Ensure that the visuals on your report canvas are configured to respond to multiple selections from the slicer. For example, if you have a table visual, it should be set up to aggregate data based on all selected items in the slicer.

The Switch function is generally not used for enabling multiple selections in slicers but rather for creating calculated columns or measures based on specific conditions.