Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Henryk
Frequent Visitor

Filter two percentage column with OR condition

Hi,

I have two columns from excel table with percentage values and I need filter it with OR condition, like:

Display ALL when column 1 is Greater then 50% OR column 2 is Greater then 40%.

 

How can I filter this two result together with slicer?

 

Here is my project file:

https://drive.google.com/file/d/1MhJqa4bBzHMUzLhO5E14KDQ_MjDAYnB_/view?usp=sharing

 

 

 

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Hi,

Thank You,

its Great, and help me a lot. You solution is very easy, another solutions from google with creating more tables ... not work for me. Please where can I find good source for learning this coding myself?

Regards,

H.

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

Thank You,

its Great, and help me a lot. You solution is very easy, another solutions from google with creating more tables ... not work for me. Please where can I find good source for learning this coding myself?

Regards,

H.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.