Unicode symbol color missing on PDF export

[msanter3344]

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 information (red, yellow, green), this means I can't use it.

This seems to be a bug.

Any ideas for using symbols to indicate the status, which work with PDF export as well?

Thanks

[MariaP · Accepted solution]

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

[msanter3344]

thanks, good idea!