Slicer - Filter By 1 of 3 columns

[zfemmer]

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?

[wdx223_Daniel]

@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

[themistoklis]

@zfemmer 

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] )

    )