Convert a SWITCH to Slicer

[y5famfnatudu]

Hello,

Is it possible to convert a SWITCH result into slicer? Putting in mind that I am not allowed to do that using calculated tables or parameters

For example, using the following SWITCH example

SWITCH (
    TRUE,
    [A] > [B], "First case",
    [A] = [B], "Second case",
    [A] = 0, "Third case",
    "Fourth case"
)

 I would like to have a slicer that contains the values:

• First case
• Second case
• Third case
• Fourth case

Thank you so much for your kind assistance.

Best regards,

Simon

[Ahmedx]

See if this approach suits you

https://dropmefiles.com/KXHUY

[y5famfnatudu]

Hello @Ahmedx,

Thank you so much. Unfortunately, that won't work, and won't be accepted as per our company's standard.

Best regards,

Simon

[Ahmedx]

create a table

Table= DATATABLE("ID",INTEGER,"Value",STRING,{
    {1,"First case"},
    {2,"Second case"},
    {3,"Third case"},
    {4,"Fourth case"}

})

[y5famfnatudu]

Hello @Ahmedx 

Thank you for your answer, but as I mentioned in my message I cannot create calculated tables or columns.

Unfortunately, that won't help.

Best regards,

Simon

[Idrissshatila]

Hello @y5famfnatudu ,

Slicers can only be used by columns, so unless you have the result in a  column then you can't visualise it in a slicer.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin