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, ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    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

     

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