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 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

 

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

     

2 Replies

  • MariaP's avatar
    MariaP
    Icon for Solution Supplier rankSolution Supplier
    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