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

Unable to select details from two visuals in the third visual (OR filter)

Hi,

 

I have an issue in Power BI. I am not sure how to do this in power BI. I have data like below :

 

data.PNG
I have two scatter plot in my visual. one has data for Company Z and other has Company X, Y 

 

I want to

 

scatter.PNGAbove is sample

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unable to select details from two visuals in the third visual (OR filter)

Hi numpy,

 

I'm afraid condition between built-in slicer chart is "AND", not "OR", as a workaround, you can create a condition column for your conditions.

 

Regards,

Jimmy Tao 

5 REPLIES 5
sailkitty Regular Visitor
Regular Visitor

Re: Unable to select details from two visuals in the third visual (OR filter)

HI- 

You can add filters to the "Visial Level Filter" in the select visual 

 

 

Or you can write a calculate statement 

CALCULATE( sum(sales), Complany="X")

CALCULATE( sum(sales), or(Complany="X",Complany="Y"))

CALCULATE( sum(sales), or(Complany="Y")

 

The latter may be helpful if your intending to use these sperate companys in further equations and want to keep them seperate

 

 

numpy Frequent Visitor
Frequent Visitor

Re: Unable to select details from two visuals in the third visual (OR filter)

Actually user want that it select company one from scatter plot 1 and competition from scatter plot 2.

And third visual would be comparison between both.

The decision of company selection is on user and hence would love to hear if it is possible to filter product based on scatter plot
Community Support Team
Community Support Team

Re: Unable to select details from two visuals in the third visual (OR filter)

Hi maty 

 

So your requirement is to achieve a scatter chart based on two slicers use or condition, right? To achieve this, you should write some dax formula to applying OR conditions between slicers in filter statement using function like UNION(), OR(), VALUES(), for more details, you may refer to blogs below:

https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5

 

Regards,

Jimmy Tao

Highlighted
numpy Frequent Visitor
Frequent Visitor

Re: Unable to select details from two visuals in the third visual (OR filter)

Hi Friend,

 

Sorry for late reply.

 

Actaully I want to filter based on selection made in scatter plot itself.

 

For example I selected X company from scatter plot(top) and Y company from scatter plot (bottom) the third visual should have both details of Company X and Comapny Y in it.

 

I hope I could explain it well.

Community Support Team
Community Support Team

Re: Unable to select details from two visuals in the third visual (OR filter)

Hi numpy,

 

I'm afraid condition between built-in slicer chart is "AND", not "OR", as a workaround, you can create a condition column for your conditions.

 

Regards,

Jimmy Tao