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.
Hi all,
I'm trying to create a chart to return net actual vs budget chart using fields in multiple tables.
Table 1:
Table 2:
Table 3:
Relationship:
Table1(Mapping) - Table 3(ExecutivePL)
Table 3(Mapping Key) - Table2(Mapping Key)
Question
I have created a DAX measure to returns net actual:
Hi @beeEc009
Please provide a screenshot of the relational data model view to understand there lationships between the tables.
Hi,
Thank you for the prompt response. I assumed that the chart should filter if slicer is added but that hasn't been the case.
there is no direct relationshipship between table 1 and table 3. It is worth mentioning that carries data labels, table 2 is a mapping table and table 3 holds all the data (fact table)- this is a new project and I just recently took over.
To simplify my request, i will attach a screenshot of how i will like my output to look.
@beeEc009 , If table 1 is on the one side of the join, you should be simply able display this measure and column from table 1
In case of other join is should also work
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |