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

Two tables with repeated filters

I have a commission table and a units sold table. Both these tables have client #. Each of these tables have "type" column which indicates for example, what type of pie is sold: raspberry pie, blueberry pie, lemon pie. But the other table with have a "type" column with raspberry pie, blueberry pie, lemon pie, apple pie, raspberry-chocolate pie.

 

Currently, I have two filters for Type from Table A and Type from Table B on my dashboard. How can I either join these tables, recode columns, or do something to allow me only one filter needed for Type rather than two?

8 REPLIES 8
awu3639
Frequent Visitor

Two tables, two of the same slicers from each table respectively, how to reduce to one filter only?

I have two tables that are not joined but they have similar columns. For example, there is a comission table and an units sold table. I have two bars: one that shows commission paid from the commission table and one that shows # units sold by the units sold table. But they share columns in common such as segment and month (time). Currently, I have replicated slicers for each table: one segment slicer for commission table and one segment slicer for units sold table, one time frame slicer for commission table and one time frame slicer for units sold table. Is there any way to make it so that I only need to put in my filters once without having to have replicated ones whenever I manipulate the dashboard data?

pxg08680 Resolver III
Resolver III

Re: Two tables, two of the same slicers from each table respectively, how to reduce to one filter on

@awu3639

Why don't you join the two tables on the common columns and have a single segment slicer and time slicer.

awu3639
Frequent Visitor

Re: Two tables, two of the same slicers from each table respectively, how to reduce to one filter on

If I join the two tables on something like segment, I will lose the granularity of each table. 

pxg08680 Resolver III
Resolver III

Re: Two tables, two of the same slicers from each table respectively, how to reduce to one filter on

@awu3639

Try creating a calculated column wich gives you the common data, somthing like an IF statement and make use of this new column as slicer.

Super User IV
Super User IV

Re: Two tables with repeated filters

Hi,

 

Paste you tables here.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
pxg08680 Resolver III
Resolver III

Re: Two tables with repeated filters

@awu3639

It would be more easy to answer if you provide some sample data.

But out my understanding, you can use calculated column to find the common type and use this as a slicer.

 

Column = IF(Table1[Type] = RELATED(Table2[Type]),RELATED(Table2[Type]))

 

 

awu3639
Frequent Visitor

Re: Two tables with repeated filters

Will this work if the columns don't exactly match? Like one table has an extra type of pie and one table has a pie named differently

Highlighted
pxg08680 Resolver III
Resolver III

Re: Two tables with repeated filters

@awu3639

It compares the values in two columns and gives you only matching result.  If one column has  OatMealPie and other column has Oat Meal Pie it doesn't match.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors