How to retrieve Slicers Data prom power BI report

[Neehar]

Hello,

I want to retrieve the Slicers data in a power bi report from all the pages.

I tried the below code, which is provided in the url getSlicers()

page.getSlicers()
        .then(slicers => {
            debugger
            console.log(slicers);
        });

 I thrown an error Uncaught (in promise) TypeError: page.getSlicers is not a function.

Please help me with a working example.

Thank You

[Anonymous · Accepted solution]

HI @Neehar,

I'd like to suggest you test on the power bi playground, it shared the sample report and corresponding code snaps of each operation:

Power BI Playground - Developer Sandbox

// Retrieve the page collection and get the slicers for the active page.
try {
    const pages = await report.getPages();

    // Retrieve the active page.
    let pageWithSlicer = pages.filter(function (page) {
        return page.isActive;
    })[0];

    const visuals = await pageWithSlicer.getVisuals();

    // Retrieve all visuals with the type "slicer".
    let slicers = visuals.filter(function (visual) {
        return visual.type === "slicer";
    });

    slicers.forEach(async (slicer) => {
        // Get the slicer state.
        const state = await slicer.getSlicerState();
        console.log("Slicer name: \"" + slicer.name + "\"\nSlicer state:\n", state);
    });
}
catch (errors) {
    console.log(errors);
}

Regards,

Xiaoxin Sheng