cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Surafel
Helper I
Helper I

How to combine two slicer into one to optimize filtering

How do I combine two filtering fields into one to filter the dashboard on the combined filter rather than having two filtering slicers individually.  For instance, I have two fields that look like below:

PBI quesiton filter.PNG

 

Now I want to combine these two fields (sort of in the form of union logic). 

 

Can I achieve this here?

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Surafel , if they are from two tables you need to create a common table using those. and Join back. even from same table , You can put them same table(Distinct Union All/Distinct) and join both columns with a new table. One join will be inactive( That you can activate in a measure using userelationship)

Common table https://www.youtube.com/watch?v=Bkf35Roman8

 

Use relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...



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!

View solution in original post

3 REPLIES 3
Surafel
Helper I
Helper I

Thank you so much @amitchandak . That was helpful. It works 🙂

amitchandak
Super User IV
Super User IV

@Surafel , if they are from two tables you need to create a common table using those. and Join back. even from same table , You can put them same table(Distinct Union All/Distinct) and join both columns with a new table. One join will be inactive( That you can activate in a measure using userelationship)

Common table https://www.youtube.com/watch?v=Bkf35Roman8

 

Use relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...



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!

View solution in original post

@amitchandak this is working fine for one of the tables that I have an active relatinship, but I am wondering how I can activate the relationship between two of the tables and the union table because I am unioning three tables and two of them have inactive relationship. Now even if I am able to union the tables, the filtering table is not being applied on those that dont have active relationship with the unioned table. How can I solve this please?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors