The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a report for financial tracking that isn't working as I'd like. There are more tables involved, but the relationships I've modeled are simple, each connecting to the Project Master Table. Then, based on their ID relationship, defines 1 to 1 or 1 to many. The data sources are SharePoint Online lists. The primary key in each table is a lookup of the ID from the Project Master Table.
I have some donut charts that use Cost Tbl 2 columns for financial data. When I select a slice of the donut chart, the other visuals, which use Project Master Tbl, do not filter. However, if I select from Project Master Tbl (example, table visualization with project names + PMs) then it will filter onto the donut chart using Cost Tbl 2. So it seems like the filtering is only happening one direction, from Project Master Tbl. I have Bi-directional relationship active for these.
Note: Cost Tbl 2 is a transformed version of Cost Tbl 1 (using Power Query). My "edit interactions" are not the issue either.
Not sure what I'm missing here... Thanks in advance.
Hi @jrdn03
please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
My org won't let me share the link, and I can't get to it easily on my personal PC. Let's try screenshots.
Here is the page by default, no selection.
Neither donut chart (based on the Funding Tbl) will affect the table visual (based on Master Project Table)
But selecting the first row in the table does affect both donut charts.
Finally, here is the model.