This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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?
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
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.