Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.