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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Create a filter by column name

Hello everyone, i was wondering if its possible to create a filter according to column name, let me explain, 

 

I have this table with the columns

 

Lender, business_name, closers, opener, gross margin

 

I want the filter to be between lenders,business_name, closers and opener

So imagine i have this 

 

 

Lender           Business Name             Opener                  Closer                  Gross Margin
Lender ABusiness AOpener ACloser A976
Lender ABusiness BOpener ACloser A454
Lender ABusiness COpener BCloser A517
Lender BBusiness DOpener CCloser A813
Lender BBusiness EOpener CCloser B810
Lender CBusiness FOpener DCloser B783
Lender DBusiness GOpener ECloser C394

 

 

now i want to filter the page by column,

if i press Lender, i want this result, it will remove or filter out all other columns and sum up the gross margin according to Lender and same as business name, opener, closer

Lender                   Gross Margin
Lender A1947
Lender B1623
Lender C783
Lender D394


and if i press business i get this result and so on ,

Business Name             Gross Margin
Business A976
Business B454
Business C517
Business D813
Business E810
Business F783
Business G394


is it possible?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , I think field parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , I think field parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors