Forum Discussion

JagadishNallami's avatar
JagadishNallami
Frequent Visitor
2 years ago

getSlicerState returning the not selected items instead of selected items

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!!

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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