cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cini_Varghese
Frequent Visitor

Get filter details of a report

I am looking for a way to get the filters associated with a report along with its possible values using rest api or javascript approach.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Cini_Varghese,

You can try to use power bi javascript 'getfilter' function to get current report page filters:

Power BI JavaScript / Filters 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @Cini_Varghese,

You can try to use power bi javascript 'getfilter' function to get current report page filters:

Power BI JavaScript / Filters 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Hi,

Is there a way to get all filter values instead of only the values that are currently applied.

Hi @Cini_Varghese,

So you mean you want to use power bi javascript to achieve the effect that similar to DAX allselected function?

I double-check the document and found the 'Persistent Filters' descriptions seem to meet your requirement, but it is a switch function and not include the feature to extract the records of these filter effects. 

So I think you need to do some processing to looping all the contents to get filters.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors