Filters target doesn't match slicer target (Hierarchy Slicer, Embedded)

[Dzvene]

We are trying to save the state of the slicers and apply them.

We get the state using getSlicerState () and, on the onLoad event, we try to apply them with .setSlicerState(),

When we try to apply the saved state, we get an error:

The state that we save and try to apply:

Why we can't use the saved state for the same slicer аnd what do we need to do to apply them?

For other slicers, it works correctly, the problem only with Hierarchy Slicer.

[shahabazshafisk]

I tried the same format for the filter and I am still getting the same error.

const filters = {

    "$schema": "http://powerbi.com/product/schema#relativeDate",

    "target": { table: "Date", hierarchy: Date Hierarchy, "hierarchyLevel": "Date" },

    "filterType": models.FilterType.RelativeDate,

    "operator": models.RelativeDateOperators.InLast,

    "timeUnitsCount": 10,

    "timeUnitType": models.RelativeDateFilterTimeUnit.Days,

    "includeToday": true

};


The the SlicerState I got upon calling getSlicerState Method

{
"filters": [
{
"$schema": "http://powerbi.com/product/schema#relativeDate",
"target": {
"table": "date",
"hierarchy": "Date Hierarchy",
"hierarchyLevel": "Date"
},
"filterType": 4,
"operator": 0,
"timeUnitsCount": 6,
"timeUnitType": 4,
"includeToday": true
}
],
"targets": [
{
"table": "date",
"column": "Date"
}
]
}

[v-xuding-msft · Accepted solution]

Hi @Dzvene ,

Please try to provide a target of type IFilterHierarchyTarget. example:

const basicFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "Store",
    hierarchy: "Country",
    hierarchyLevel: "Code"
  },
  operator: "In",
  values: [456, 943],
  filterType: pbi.models.FilterType.BasicFilter
};

visual.setSlicerState({
    filters: [basicFilter]
});

Reference:

https://github.com/Microsoft/PowerBI-JavaScript/wiki/Slicers

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.