Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter / Slicer not affecting Chart Axis nor Table

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous 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).

  • Anonymous's avatar
    Anonymous
    7 years ago

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous 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).

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

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