The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
)
Solved! Go to Solution.
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.
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
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.
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
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 .