Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
stribor45
Post Prodigy
Post Prodigy

Character not showing up

Sometimes the up or down character does now show in service and I am wondering what I can do to fix this. This doesnt happen all the time and it doesnt have any patterns. I have refreshed report multiple times, republished in service and changed dates on my slicer to see if changes will apear to no luck.   Changing the browsers did not resolve it. It works fine in Desktop

 

stribor45_0-1707398285177.png

 

This is ow up and down arrows are generated

 

ICONS_CHANGE = SWITCH (TRUE(),
           [% measure a] > 0.01, UNICHAR(9650), 
           [% measure a] <= 0.01, UNICHAR(9660)
)

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @stribor45 ,

You can try this DAX:

Measure = IF([% measure a] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Connect the labels directly to the data so that changes to the data directly change the up and down labels and the data

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Hi @stribor45 ,

You can try this DAX:

Measure = IF([% measure a] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Connect the labels directly to the data so that changes to the data directly change the up and down labels and the data

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

this is good and it works in service but the problem is that you can apply the conditional formating rules since this is of type text. i need to apply colors as well to this

Anonymous
Not applicable

Hi @stribor45 ,

You can use the Reference labels in the new card visual object to add labels for your four measures, and then you can modify its color according to the appropriate rules.

vxiandatmsft_0-1707699678112.png

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I know but to use that I have to create a new measure and use that instead of the original value [% measure a] which is now text and not a number anymore. That's what I was trying to avoid because it caused me a problem of Unicode not rendering in service. Looks like that is my only option anyway to change the colour

this worked for me when I connected the labels to data directly but this brought forward another question.

 

I have 4 different measures  (measures A, B, C and D) and they all have different values (see code below). Is there to shorten this code? It seems redundant and the only difference is the measure used.

 

Measure Show A = IF([% measure a] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show B = IF([% measure b] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show C = IF([% measure c] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

Measure Show D= IF([% measure d] > 0.01 , UNICHAR(9650) , UNICHAR(9660)) & FORMAT([% measure a],"0.0%")

 

 

Calculation Groups?

I saw that but that requires downloading new software etc for only 4 measures. 

Not any more! You can do that now natively in Power BI Desktop.  Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.