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.
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
Solved! Go to 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
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
thanks, good idea!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |