Slicers with CUBEVALUE|Power Query|Excel Forum|My Online Training Hub

I read your post https://www.myonlinetraininghu.....vot-charts for including grand totals with pivot charts. I've created a pivot table that is connected to a slicer that feeds a pivot chart. The pivot table works just like expected and reacts perfectly to the slicer. I want to include Grand Totals on my graph so I tried the OLAP method.  That worked great too until I tried connecting the formulas to the slicer.  When I created the OLAP formulas, this is what I got "=CUBEVALUE("ThisWorkbookDataModel",$B$2,$B$3,$B$4,$A$6,$A8,B$7)".  It is slightly different than the one from your example. Thaat is because I have three filters in B2:B4.  My Slicer in named Slicer_NAME2.  When I add it to the formula as mention in your post, I get a #VALUE! error.  Do you know why and how to fix it?

[Image Can Not Be Found]