Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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] )
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |