Slicer Using Colour

[tksnota]

Hi,

Is it possible to create slicer using colour see screenshot?

Regards,

Noel

[Anonymous · Accepted solution]

Hi @tksnota 

Thanks for the reply from @lbendlin .

@tksnota , are you trying to use the color directly as a slicer? I'm afraid that's not directly possible.

From your screenshot, there are three ranges, namely greater than 0, between -5 and 0, and less than -5. Here is a simple test I created for your reference:

My sample:

Then I created a calculated column as follows.

Column = SWITCH(TRUE(),
[Value] > 0, "> 0",
[Value] <= 0 && [Value] >= -5, "-5 - 0",
[Value] <-5, "< -5")

use this column as a slicer:

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That's a table visual, not a slicer?