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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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