Forum Discussion
msanter3344
6 years agoNew Member
Unicode symbol color missing on PDF export
Hello, For status indication I use the unicode character 128994 (green circle), which is displayed nicely on screen, but on exported PDF the circle misses the color. As the color holds the main i...
- 6 years ago
Hi msanter3344 ,
You could try arrows or ticks. I tried these and they export correctly from desktop. Although there is no colour a tick/cross/exclamation mark is universally understood so better design overall!
ArrowsMaria = SWITCH( TRUE(), ISBLANK([Previous Month Sales]) || ISBLANK([Sales Amount]), BLANK(), [Sales Amount] <= 0, UNICHAR(9758), [Sales Amount] >= [Previous Month Sales], UNICHAR(11165) , //up arrow [Sales Amount] <= [Previous Month Sales], UNICHAR(11167), // down arrow UNICHAR(9758) //BLANK() )TicksMaria = SWITCH( TRUE(), ISBLANK([Previous Month Sales]) || ISBLANK([Sales Amount]), BLANK(), [Sales Amount] <= 0, UNICHAR(128500),//cross [Sales Amount] >= [Previous Month Sales], UNICHAR(128504) , //tick [Sales Amount] <= [Previous Month Sales], UNICHAR(33),//exclamation UNICHAR(9758) //BLANK() )See ticks code: https://exceleratorbi.com.au/dax-unichar-function-power-bi/
Cheers,
Maria
MariaP
Solution Supplier
6 years agoHi msanter3344 ,
You could try arrows or ticks. I tried these and they export correctly from desktop. Although there is no colour a tick/cross/exclamation mark is universally understood so better design overall!
ArrowsMaria = SWITCH(
TRUE(),
ISBLANK([Previous Month Sales]) || ISBLANK([Sales Amount]), BLANK(),
[Sales Amount] <= 0, UNICHAR(9758),
[Sales Amount] >= [Previous Month Sales], UNICHAR(11165) , //up arrow
[Sales Amount] <= [Previous Month Sales], UNICHAR(11167), // down arrow
UNICHAR(9758)
//BLANK()
) TicksMaria = SWITCH(
TRUE(),
ISBLANK([Previous Month Sales]) || ISBLANK([Sales Amount]), BLANK(),
[Sales Amount] <= 0, UNICHAR(128500),//cross
[Sales Amount] >= [Previous Month Sales], UNICHAR(128504) , //tick
[Sales Amount] <= [Previous Month Sales], UNICHAR(33),//exclamation
UNICHAR(9758)
//BLANK()
)
See ticks code: https://exceleratorbi.com.au/dax-unichar-function-power-bi/
Cheers,
Maria
msanter3344
6 years agoNew Member
thanks, good idea!