cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to ensure that all the slicers on the same page have the same input

Hi ,

 

I have three slicers on a page that is used as a comparison view. There is one slicer for each comparison and I've got three categories so there are three slicers. The input to these three slicers should be the same but each slicer is filtering the data differently. The slicers are 30, 60, 90 day predictions and the range of the slicer is probability between 0 and 1. Theortically, a user would like to compare the same probability arcoss the 30, 60, 90 day predictions. Is there any way where I can just use a something that would take the user input like a variable and apply it to the three slicers instead of manually typing the same probability three times? 

2 REPLIES 2
Super User IV
Super User IV

@pluto556 - You could use a What If parameter but not sure if you could program the slicers to do anything with it, maybe creating a measure that sets some filters on what to include in each slicer, like:

 

It's hard to be specific though without sample data and expected output and how your data model is laid out.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

@pluto556 , I did not get it completely. What if parameter is the way to take user input.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors