Forum Discussion

MuppetyMe's avatar
MuppetyMe
Helper I
1 year ago
Solved

Slicer Help - Categorizations

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 slic...
Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    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's avatar
v-sgandrathi
Community Support
1 year ago

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!