Forum Discussion
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
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)
)
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.
9 Replies
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 .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 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?
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
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.
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.
