cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Filter Table Without Including the Column You are Filtering On

Hi,

I have a fact table:

AccountType

1A
2B
3B
4C
2C
1C
1A
3A
1D
4C

 

With an Account dimension:

AccountName

1W
2X
3Y
4Z

 

So there is 4 Accounts (W, X, Y and Z) and the fact table has 4 Types (A, B, C and D).

 

I want to create a table showing the Account names that filters with a slicer for Type. The problem is that I don't want Type to be one of the columns displayed in the table. But if I don't include it in the table, the slicer won't apply and the table will just show a list of all accounts.

 

Does anyone know a way around this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Supplier
Solution Supplier

Re: Filter Table Without Including the Column You are Filtering On

It sounds like you want bi-directional filtering on the relationship between the tables (I'm assuming you have a one-to-many relationship from Dimension[Account] 1 -->-- *  Fact[Account] ).

 

Bi-directional relationships can cause relationship ambiguities though so it may be better to do the cross-filtering within whatever measures you are using.

View solution in original post

1 REPLY 1
Highlighted
Solution Supplier
Solution Supplier

Re: Filter Table Without Including the Column You are Filtering On

It sounds like you want bi-directional filtering on the relationship between the tables (I'm assuming you have a one-to-many relationship from Dimension[Account] 1 -->-- *  Fact[Account] ).

 

Bi-directional relationships can cause relationship ambiguities though so it may be better to do the cross-filtering within whatever measures you are using.

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors