Filter based on conditonal formatted UNICHAR 11044

[Anonymous]

Hey guys,

I would like to create a Slicer in order to filter based on color. I made the following steps:

1, KPI Light as UNICHAR11044

2, With conditional formatting I changed the color (green, yellow, red)

3, Made a Slicer based on KPI Light.

The problem I'm facing is that it only shows the black UNICHAR 11044, and not the colored one.

Do you know by ancy chance, how I could filter based on the different colored UNICHARs?

Any help is greatly appreciated.

Many thanks,

Adam

[v-lili6-msft · Accepted solution]

hi, @Anonymous

After my test, you had added a calculate column KPI Light = UNICHAR(11044)

so KPI Light for all the rows are UNICHAR(11044) and slicer only has a value.

And if you could add a column like this 

KPI Light = UNICHAR(IF(Table1[Colour]="green",11165,IF(Table1[Colour]="red",11166,11167)))

then filter by KPI Light.

By the way, 11044 is not return the Unicode character not color code.

Reference:

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

https://unicode-table.com/en/#

Best Regards,
Lin