Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Get slicer data from powerbi page

Is there any way to get dropdown options from a slicer via any javascript library or any REST API? 


Consider if we have a slicer called City, which have dropdown options like Sydney, Melbourne, Brisbane etc. What's the possible way to get these values programmatically?

Solution Sage
Solution Sage

Hi @Harshasripathi ,
I am not sure if you can connect specifically slicer itself but you can connect the underlying data, which is used for any visual.
For example. If you have Premium workspace, you can use XMLA endpoint to connect to your dataset via tabular editor or MS SQL server management studio and get data from "City" column in a "Programmaticall" way.


If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.