- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Column Chart Filter On 2 Fields
I have a column chart (using Table 2) that I'm trying to filter a data table (Table 1) based on 2 fields (LOB1 and LOB2).
Table 1:
Asset | CORP | TV | LOB APP | LOB1 | LOB2 |
A | 1 | 1 | CORP, TV | CORP | TV |
B | 1 | 0 | CORP | CORP |
Table 2:
LOB | Count |
CORP | 2 |
TV | 1 |
Table 1 essentially contains my raw data and there are situations where an Asset (such as A) can have more than one LOB. In my graph, I want to be able to click on CORP and Asset A and B would show up. (This is what I currently have). And then, if I click on TV, only Asset A would show up.
I currently have the two tables linked together, just so that I can have the counts created to create a column chart.
And then if I click on CORP in the chart, both Asset A and B will show up on the table - which is great.
But then, I want to click on TV and only have Asset A show up. For the table relationships, I can only figure out a way to just do one active relationship, so it is currently just LOB to LOB1.
And for now, nothing will show for Asset A in the table.
Is there a way to have an override with two active relationships? I know I can also have Asset A appear as 2 rows of data, but I'd like to ideally keep it all as 1 row.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, can you add asset to your Table 2 and create relationship based on the Asset? Crossfilter both: then it functions quite like you want it to.
DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, can you add asset to your Table 2 and create relationship based on the Asset? Crossfilter both: then it functions quite like you want it to.
DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This works wonderfully - thank you!!
I was going crazy on how to get this to work, appreciate it so much!

Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
63 | |
55 | |
54 | |
36 | |
34 |
User | Count |
---|---|
76 | |
73 | |
46 | |
45 | |
43 |