Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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
@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
User | Count |
---|---|
21 | |
20 | |
12 | |
10 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |