Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
priyanka1985_
New Member

For Custom Visual, filter needs to apply for 2 columns using applyjsonfilter

For Custom Visual, filter needs to apply for 2 columns using applyjsonfilter

tried calling basicfilterapi twice for 2 different column but it always take last filter  and also using the filterAction as merge but metadata.objects.general.filter always takes the last filter data it is not merging the previous filter with the new one.

 

Even tried the Advancedfilter , with logicaloperation as AND and in conditon passed the aaray of column and values but it doesnt and used the applyJsonFilter method with filteraction as merge, but it doesnt work.

 

It is not evening calling the VisualUpdateoption method to update the visual, even top N filter is also not working, 

 

Please suggest how to filter the data from 2 columns in cutstom visual using filter api?

 

 

 

 

 

 

1 REPLY 1
dm-p
Super User
Super User

Hi @priyanka1985_,

 

I haven't tested it, but IIRC you need to use a Tuple Filter for multiple columns; basic and advanced filters can only use a single column.

 

Regards,


Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors