Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
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.
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
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
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.
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
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |