I have an issue in Power BI. I am not sure how to do this in power BI. I have data like below :
I have two scatter plot in my visual. one has data for Company Z and other has Company X, Y
I want to
Solved! Go to Solution.
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
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:
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.