Forum Discussion
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: Table 2: Table 3: Relationship: Table1(Mapping) - Ta...
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.