Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi there,
I am having a slicer with hierachial data. When I tried to get the state of the slicer, I am getting the "Not selected" information instead of selected information like below. As it is a hierarchial data, I am having a tough time getting the selected data by filtering.
can anyone help me if there is a way to fetch the selected instead of NotSelected?
It helps a lot. Thank you in advance!!
Hi @JagadishNallami ,
Base on your description, it seems like you are trying to get the selected values of hierarchies data in a slicer when using "getSlicerState" in Power BI. Please try the below codes:
Use slicers in Power BI embedded analytics | Microsoft Learn
// First, get the slicer state
slicer.getSlicerState().then(slicerState => {
// slicerState.values contains the state information
const selectedValues = slicerState.filters
.filter(filter => filter.isNotSelected === false) // Filter out the "NotSelected" items
.map(filter => filter.value); // Extract the selected values
console.log("Selected Values: ", selectedValues);
}).catch(error => {
console.error("Error fetching slicer state: ", error);
});
Best Regards