Slicer not applying to entire chart

[jdierk]

I am trying to create a dashboard. On my chart in the top left it has the data listed for actuals and budget. But when I try to apply the month slicer to the data it only applies it to the budget column, not the actuals. How can I get the actuals column to use the slicer as well?

Without slicer applied:

With Slicer Applied:

Model View:

[Ashish_Mathur · Accepted solution]

Hi,

Do not create any relationship between the Budget and Actual tables.  Create a Calendar Table with calculated column formulas of Year, Month name and Month number.  Sort the Month name column by the Month number.  Create a relationship (Many to One and Single) from the Date column of the Budget and Actual tables to the Date column of the Calendar Table.  To your visual/slicer/filter, drag any date field from the Calendar Table.

Hope this helps.

[jdierk]

This worked for me, thank you for your help!

[Ashish_Mathur]

You are welcome.

[v-huijiey-msft]

Hi @jdierk ,

From the screenshots you provided, it looks like slicer can correctly interact with the table visual objects and that relationships are established between the tables.

I noticed that your relationship is * : *, please check if the crossfilter setting for tables in the model view is "both", you can change it to "single" to see if it works correctly.

Is Unit Actuals MW a measure?

If so, check the syntax in the measure for any filter context conflicts.

Make adjustments as needed to ensure consistent results.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!