• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change slicer item based on a cell value for OLAP Cube

mamunurbaf

New Member
Hello.

One of my dashboard is connected with OLAP cube, I wanted to change a slicer from a cell value but due to shortage of vb expertise, I cant make it possible. Any help is highly appreciated. I can change slicer statistically like below but I need dynamic changing of slicer.

Code:
If Sheets("Reports").Range("A2") = "2019/20" Then
'ActiveWorkbook.SlicerCaches("Slicer_Fin_Year").VisibleSlicerItemsList = Array("[02 All Dates].[Fin Year].[03 Fin Year].&[2019/20]")
End if

Note. My sheet name = Report
Cell value in A2 = 2019/20
Need to change slicer when cell value is change accordingly

Thank you
Nayeem :)
 
Last edited by a moderator:
Hi

Thank you, but the file is connected to the Cube and it's more than 100MB :-S..

Is there any other way to sort it out please.

Apologise for the issue
 
Back
Top