Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Slicer to filter chart using DAX

Hi all,

I'm trying to create a chart to return net actual vs budget chart using fields in multiple tables.


Table 1: 

Screenshot 2023-03-13 121657.png

Table 2:

Screenshot 2023-03-13 121710.png

Table 3:

Screenshot 2023-03-13 122308.png



Table1(Mapping) - Table 3(ExecutivePL)

Table 3(Mapping Key) - Table2(Mapping Key)


I have created a DAX measure to returns net actual:

Actual Net Result =
    SUM('Table 2'[Value]),
    'Table 2'[Header]="Actual"
How do I filter measure to show Net Actual for Table1 [Line item]? So chart returns only sum of actuals for e.g Utilities when selected. Thanks.
Super User
Super User

Hi @beeEc009 
Please provide a screenshot of the relational data model view to understand there lationships between the tables.


Screenshot 2023-03-13 151114.png

It should work

Regular Visitor

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.

Screenshot 2023-03-13 145718.png

Super User
Super User

@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.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.