Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |