Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Thank you so much for your kind assistance.
Best regards,
Simon
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
create a table
Table= DATATABLE("ID",INTEGER,"Value",STRING,{ {1,"First case"}, {2,"Second case"}, {3,"Third case"}, {4,"Fourth case"} })
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
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👍
Proud to be a Super User! | |
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |