Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |