Slicer Help - Categorizations

[MuppetyMe]

Looking for assistance creating a slicer for a set of data, but I'm not even sure it's possible. Below is my sample set. 

I want my slicer to have two options: "Pipeline" and "Revenue". This slicer is intended to filter a stacked bar chart where X axis = Month, Y axis = Amount, Legend = Status. 

The catch: all rows are Pipeline, but only rows with "Won" in the Status column are Revenue.

Initially, I created a new column:  

Pipeline or Revenue Text = IF(Table[Status] = "Won", "Revenue", "Pipeline")

... but I need the Won Amount to be included in Pipeline too so this doesn't work. 

I feel like I'm overlooking something super obvious (apologies in advance if that's the case). I understand that making Status a slicer would work, but that's not the direction we need to go. Anyone have thoughts on how to accomplish this? 

Table

Date	ID	Status	Amount
1/14/2025	12172	Lost	$24,833.12
1/21/2025	12173	Lost	$2,174.00
2/1/2025	12174	Won	$35,488.14
2/3/2025	12175	In Process	$12,446.85
2/17/2025	12176	Won	$24,688.10
2/22/2025	12177	Won	$1,354.00
3/14/2025	12178	In Process	$841.68
3/22/2025	12179	Lost	$54,887.25
3/23/2025	12180	In Process	$899.16
4/5/2025	12181	In Process	$35,748.00
4/17/2025	12182	Lost	$22,488.30
4/25/2025	12183	Won	$5,168.00
5/1/2025	12184	In Process	$4,721.10
5/12/2025	12185	In Process	$31,864.57
5/20/2025	12186	Won	$23,458.00
5/25/2025	12187	Won	$2,435.45

For illustration purposes, here's the gist of what I'm looking for: 

[MFelix · Accepted solution]

Hi @MuppetyMe ,

Create a disconnected table with the two values:

Pipeline

Revenue

Then add the following measures:

Total = SUM('Table'[ Amount ])


total Values = 

SWITCH(
    TRUE(),
         SELECTEDVALUE('Type Selection'[Type]) =  "Pipeline"  , [Total],
         SELECTEDVALUE('Table'[Status]) ="Won" && SELECTEDVALUE('Type Selection'[Type]) = "Revenue", CALCULATE([Total], 'Table'[Status] = "Won"))

See PBIX attached.

[v-sgandrathi]

Hi @MuppetyMe,

Thank you @Ashish_Mathur amd @MFelix for your response and for providing the attached file.
You may refer to the answers included, and I am also sharing the PBI xfile for your reference. Kindly review it at your convenience.

I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.

If you found this post useful, kindly give it a ‘Kudos’ and mark it as a solution so others facing similar challenges can find it more easily.

Thanks for being part of the Microsoft Community!

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[MFelix · Accepted solution]

Hi @MuppetyMe ,

Create a disconnected table with the two values:

Pipeline

Revenue

Then add the following measures:

Total = SUM('Table'[ Amount ])


total Values = 

SWITCH(
    TRUE(),
         SELECTEDVALUE('Type Selection'[Type]) =  "Pipeline"  , [Total],
         SELECTEDVALUE('Table'[Status]) ="Won" && SELECTEDVALUE('Type Selection'[Type]) = "Revenue", CALCULATE([Total], 'Table'[Status] = "Won"))

See PBIX attached.

[MuppetyMe]

Thank you @MFelix and @Ashish_Mathur! Both of your suggestions (almost the same, but slightly different) solved my issue. Appreciate your time and help!