Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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).
I think I got it, thank you for helping. It was the table it was pulling from!
@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).
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?
I think I got it, thank you for helping. It was the table it was pulling from!