Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.