Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Currently I am trying to use one slicer to filter on two queries within the same report that controls a graph.
Forecast Query, has a column "CC 2" and Actuals Query has a Company Code column, they both have the same values with in them (1000, 2030, & 2090).
The graph is a bar and line graph. The bars are pulling from Actuals and the line is pulling from Forecast, when selecting the slicer to filter on"1000" I would like both the line and bar graph to updated. Currently I have to have 2 slicers and select a "1000" on both for the bar and line graph to update.
Pleaseee Help.
Thanks!!