Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter based on conditonal formatted UNICHAR 11044

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

Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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