Forum Discussion

msanter3344's avatar
msanter3344
New Member
6 years ago
Solved

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...
  • MariaP's avatar
    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