Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to be able to give the end-user the ability to filter by 1 of 3 columns, but not any more than that. The columns are MarketSegment, Source, and SourceSummary.
I have the following dataset; just a small sample:
Date | Status | MarketSegment | Source | SourceSummary | BookedRevenue |
09/10/20 | Consumed | Online Travel Agents | Online Travel Agents | Online Travel Agent | 759.94 |
03/22/19 | Consumed | National Corporate | Direct Reservation | NCC | 313.47 |
06/28/19 | Consumed | Online Travel Agents | Online Travel Agents | Online Travel Agent | 1871.29 |
10/30/19 | Cancelled | Discount/Promo | National Call Center | NCC | 151.99 |
04/15/19 | Cancelled | Discount/Promo | Direct Reservation | NCC | 90.24 |
09/12/19 | Consumed | Discount/Promo | Direct Reservation | NCC | 582.51 |
08/10/19 | Consumed | Online Travel Agents | Online Travel Agents | Online Travel Agent | 1713.37 |
10/07/20 | Consumed | Retail | Direct Reservation | NCC | 579.96 |
05/04/20 | Consumed | Online Travel Agents | Online Travel Agents | Online Travel Agent | 94.99 |
01/24/19 | Consumed | Local Corporate | Direct Reservation | NCC | 94.99 |
04/15/19 | Cancelled | Discount/Promo | Direct Reservation | NCC | 179.38 |
07/25/19 | Consumed | Local Corporate | National Call Center | NCC | 380 |
10/09/19 | Consumed | Online Travel Agents | Global Dist. System | GDS | 787.95 |
I would like the end-user to be able to select which column they want to filter by:
Then potentially this would filter another slicer to show those values:
I have tried a few different data models and I cannot figure out a way to do this.
Anyone have any ideas?
@zfemmer using Power Qurey, you can create a table to combine three columns like this
then add Category and Content to two slicers respectively, and use the measure like this
TTL = CALCULATE(SUM(SampleTable[BookedRevenue]),FILTER(SampleTable,SampleTable[MarketSegment] IN VALUES(SlicerTable[Content])||SampleTable[Source] IN VALUES(SlicerTable[Content])||SampleTable[SourceSummary] IN VALUES(SlicerTable[Content])))
finally, the result as below
This thread will help you.
https://community.powerbi.com/t5/Desktop/Fieldnames-in-slicer-for-1-chart/m-p/1419019#M599357
Create a field in a reference table that will have the values 'Market Segment', 'Source' and 'Source Summary'.
Add the field above in chiclet slicer visual (if you want). The buttons are shown as in your image
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380756?tab=Overview
Then create the measure
My variabele col =
VAR Selection =
SELECTEDVALUE ( 'Ref table'[Variable] )
RETURN
SWITCH (
Selection,
"Market Segment", MAX ( 'Maintable'[Market] ),
"Source", MAX ( 'Maintable'[Source] ),
"Source Summary", MAX ( 'Maintable'[SourceSummary] )
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |