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.
A vba script that restrict the slicer to show only certain values will also be enough .
IAM USING 2013 EXCEL
Hope you got an idea of the issue
looking forward for suggestions and tips
thank you
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.
A vba script that restrict the slicer to show only certain values will also be enough .
IAM USING 2013 EXCEL
Hope you got an idea of the issue
looking forward for suggestions and tips
thank you
