topic Convert default AND to OR using Custom Visuals in Developer

Convert default AND to OR using Custom Visuals

pbiembeded — Thu, 07 Jan 2021 15:19:59 GMT

I would like to create custom visuals to convert default AND to OR logical operator.

I am able to do this using DAX query. https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

Do you know how I can achieve this by cresting custom visuals. Is there any existing slicer which will do for me ?

Is there any way in powerbi I can execute query by passing parameters through custom visuals ?

Like Entity Framework Or Ado.Net ?

Re: Convert default AND to OR using Custom Visuals

Greg_Deckler — Thu, 07 Jan 2021 16:21:37 GMT

@pbiembeded - I am not aware of any default slicer that would act that way or any slicer in AppSource that functions like that. Would need more specifics on the data you have and what you are trying to achieve to see if there is a different creative work-a-round. If you can get your filtering options into a single slicer, a single slicer by default implements OR logic within it so that *may* be an option. But, again, would need to understand your data better.

Re: Convert default AND to OR using Custom Visuals

dm-p — Thu, 07 Jan 2021 17:51:48 GMT

Hi @pbiembeded,

I provided these details on your other post. Including on this post in case you have not seen it, as I believe it provides the necessary technical details from a custom visual perspective.

Regards,

Daniel