Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sagarsahoo_123
Helper IV
Helper IV

how to bring multiple option working correctly for a measure used in slicer in power bi.

Hi Team, 

Any kind of help is really appriciated for the issue raised here.

I am using a measure into slicer and it is working absolutely fine for single selection. But when i changed the slicer to multiple option selected, and i started to choose more than one option in slicer, it is showing all the value of that table. It is not showing as per my selection. For example i have a column having work time filled per user month wise. I have created a measure to bring the range in this. Image is shown below for the selected input range. Here it is of single selection and working fine. But my organisation asked me to bring multiple selection option at a time. Please help how can i bring this! 

sagarsahoo_123_0-1679396461151.png

if i will bring this into multiple selection, here the issue i a facing highlighted in yellow below.Though i have selected to show only <4 and 4 to 6 hours range but it is showing all.

sagarsahoo_123_1-1679396740685.png

Please advice how can i bring this! Thanks in advance for your quick support.

 

Regards,

Sagar

 

 

1 ACCEPTED SOLUTION
WinterMist
Impactful Individual
Impactful Individual

@sagarsahoo_123 

 

Please try the following:

 

1) Create the following measure "Control" to identify whether a row should be included in the slicer selection.

 

WinterMist_0-1679412539665.png

 

NOTES:

- In the code above, 'Slicer' is the name of the disconnected slicer table.

- 'Slicer'[Option] is the name of the column for selectable options.

WinterMist_0-1679413204287.png

 

2) Test the Control measure.  It appears to be working in each scenario.

Here are a few examples.

 

 

WinterMist_1-1679412662586.png

 

WinterMist_2-1679412713020.png

 

WinterMist_3-1679412806780.png

 

3) After successful testing, use the "Control" measure in a filter on the table visual.

WinterMist_5-1679412901587.png

 

WinterMist_6-1679413013763.png

 

Hope this is helpful to you.

 

Regards,

Nathan

View solution in original post

2 REPLIES 2
WinterMist
Impactful Individual
Impactful Individual

@sagarsahoo_123 

 

Please try the following:

 

1) Create the following measure "Control" to identify whether a row should be included in the slicer selection.

 

WinterMist_0-1679412539665.png

 

NOTES:

- In the code above, 'Slicer' is the name of the disconnected slicer table.

- 'Slicer'[Option] is the name of the column for selectable options.

WinterMist_0-1679413204287.png

 

2) Test the Control measure.  It appears to be working in each scenario.

Here are a few examples.

 

 

WinterMist_1-1679412662586.png

 

WinterMist_2-1679412713020.png

 

WinterMist_3-1679412806780.png

 

3) After successful testing, use the "Control" measure in a filter on the table visual.

WinterMist_5-1679412901587.png

 

WinterMist_6-1679413013763.png

 

Hope this is helpful to you.

 

Regards,

Nathan

Hi @WinterMist ,

Aboslutely fantastic. Really what i was looking for. You saved my day. Thanks a lot for your quick support.

 

Regards,

Sagar

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.