Modifying a slicer

[RichFlorida]

I have a single-select slicer based on a column in a table. The column has three values: Emergency, Priotity and Routine, see image below.

Is there a way to use DAX to add a 4th option to the slicer for users to choose from, the 4th option would be, a combination of Emergency and Priority, while keeping the slicer a single-select.

[Anonymous]

Hi @RichFlorida,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[Anonymous]

Hi @RichFlorida ,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If the community member's answered your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.

If you need any further assistance, feel free to reach out.

Thanks,
Pavan.

[Anonymous]

Hi @RichFlorida ,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer resolved your query, please mark it as "Accept as  Answer" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Thanks,
Pavan.

[Anonymous]

Hi @RichFlorida 

Thank you for reaching out on the Microsoft Community Forum.

To achieve this, we have created sample data with the following DAX query:

FilterLogic = 
SWITCH (
    SELECTEDVALUE(SlicerTable[Selection]),
    "Emergency", FILTER(SlicerTable1, SlicerTable1[Selection] = "Emergency"),
    "Priority", FILTER(SlicerTable1, SlicerTable1[Selection] = "Priority"),
    "Routine", FILTER(SlicerTable1, SlicerTable1[Selection] = "Routine"),
    "Emergency + Priority", 
    FILTER(SlicerTable1, SlicerTable1[Selection] IN {"Emergency", "Priority"})
)

Additionally, I'm sharing the screenshot and PBIX file of the output.

If this meets your requirements, please "Accept as a solution." Otherwise, please explain your  scenario

Thanks,
Pavan.

[siddhesh_mane]

You can create an extended table with the Dim table values. Something like this.

The values in your Dim Table. Column2 will be your key.

Your Extended Dim Table can be created like this

I've added a new value (Emergency/Priority) to the table and assigned both key values (E11 and P11) to this. 
Once you've created a relationship between these two dim tables, in your power bi canvas you need to bring the extended table as a slicer and it should work.

Hope this helps.

[johnt75 · Accepted solution]

You would need to create a new table with 2 columns, 1 for the label you wanted in the slicer and 1 for the actual type. "Emergency or priority" would have 2 rows, one for each of the actual types. You could use DAX to create this

Slicer Table =
SELECTCOLUMNS (
    {
        ( "Emergency", "Emergency" ),
        ( "Priority", "Priority" ),
        ( "Routine", "Routine" ),
        ( "Emergency or Priority", "Emergency" ),
        ( "Emergency or Priority", "Priority" )
    },
    "Label Type", [Value1],
    "Actual Type", [Value2]
)

Link the actual type column to your main table in a many-to-many single direction relationship, so that the slicer table filters the main table. Use the slicer table in your slicer visual.

[Arul]

@RichFlorida ,

In Power BI, slicers are directly connected to the data in your model, and you cannot add items to a slicer that do not exist in the underlying data.