Filter / Slicer not affecting Chart Axis nor Table

[alliemeyerhoefe]

Hello,

I am trying to relate my slicer for location, months, and years to the charts and tables listed in my report. The slicer does not affect anything and I cannot figure out why...

[Seth_C_Bauer · Accepted solution]

@alliemeyerhoefe What does the model look like, are the slicers from a different table or the same one? If it is a seperate table you need to make sure the datatype and format are the same. (remove time from dates, for example).

[Seth_C_Bauer · Accepted solution]

@alliemeyerhoefe What does the model look like, are the slicers from a different table or the same one? If it is a seperate table you need to make sure the datatype and format are the same. (remove time from dates, for example).

[alliemeyerhoefe]

They are from different tables, but all connect by location, Business, and Country for example. I have one report that this works well, but my issue is that the slicer is only working in the report with tables and does not affect charts or graphs. Is there a simple reason why a slicer would not affect a chart or graph?

[alliemeyerhoefe · Accepted solution]

I think I got it, thank you for helping. It was the table it was pulling from!