Create a filter by column name

[Anonymous]

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 A	Business A	Opener A	Closer A	976
Lender A	Business B	Opener A	Closer A	454
Lender A	Business C	Opener B	Closer A	517
Lender B	Business D	Opener C	Closer A	813
Lender B	Business E	Opener C	Closer B	810
Lender C	Business F	Opener D	Closer B	783
Lender D	Business G	Opener E	Closer C	394

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 A	1947
Lender B	1623
Lender C	783
Lender D	394

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

Business Name	Gross Margin
Business A	976
Business B	454
Business C	517
Business D	813
Business E	810
Business F	783
Business G	394

is it possible?

[amitchandak · Accepted solution]

@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