topic Re: Slicer to filter chart using DAX in DAX Commands and Tips

Slicer to filter chart using DAX

beeEc009 — Mon, 13 Mar 2023 01:35:07 GMT

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:

Actual Net Result =

CALCULATE(

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.

Re: Slicer to filter chart using DAX

amitchandak — Mon, 13 Mar 2023 02:39:21 GMT

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.

Re: Slicer to filter chart using DAX

beeEc009 — Mon, 13 Mar 2023 03:57:48 GMT

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.

Re: Slicer to filter chart using DAX

tamerj1 — Mon, 13 Mar 2023 04:06:07 GMT

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

Re: Slicer to filter chart using DAX

beeEc009 — Mon, 13 Mar 2023 04:16:20 GMT

Hi,

Re: Slicer to filter chart using DAX

tamerj1 — Mon, 13 Mar 2023 04:24:35 GMT

beeEc009
It should work