none
POWER PIVOT : VBA SCRIPT ON SLICER TO HIDE VALUES RRS feed

  • Question

  • Hi,

    Can someone help in vba coding to assign to slicer in power pivot report.I have a slicer with blank values coming. i have to hide those blank values.  My Model is SSAS tabular model . Since the tabular model wont support outer join these blank values are coming in the slicer.

    ie, i have a column called "fact.measures " in fact table and have   two dimension tables  called dim.measures1 and dim.measures2( measures2 is a subset  of measures1) . The measures2.measures column have only 4 members  : budget,cost, revenue, margin where as measures1.measures have more values in addition to above 4 members.

    Iam joining two dimensions to the fact table. Since measures2.measures  have only 4 members in the column and fact have more members iam getting blank values in the measures2.measures  . Since i cannot have any other logic in the model only option is to hide those blank values in the slicer created on the measures2.measures.

    can someone help me with a vba code to hide this blank value. "Hide items with no values " in the slicer property will not work since these blank sell have values in the fact table.

    IAM USING 2013 EXCEL

    Hope you got an idea of the issue

    looking forward for suggestions and tips

    thank you


    • Edited by BItechie Tuesday, November 18, 2014 12:34 PM
    Tuesday, November 18, 2014 12:30 PM