Forum Discussion
Bug in April 2023 update - Dynamic format string
Hi All,
I have tried the new Dynamic format strings for measures but have noticed for few of the numbers (% Ratings) in dashboard show wrong values. If you check in the attached Dashboard, if the % Rating is 10%,20%,30%,40%,50%,60%,70%,80%,90% or 100% then the rating is multiplying with 11. Example if the Rating is 0.6(60%) then it display 660%. Apart from these rounding rating numbers everything else display perfectly. Even the bar size looks fine. see pics for refferences.
- creating measure for % Rating with Dynamic format
- Selecting the format and specifying format for the % Rating and adding if the % Chg is >1.645 then Green dot, <1.645 Red Dot else nothing.
- Created the Matrix view with bars as conditional format for values(%Rating). Here for Measure_1 BB it's 660% but actaul value is 60% and for Measure_2 all are 100% but display as 1100% means it's multiplying 11.
- But for Measure_7 all the values looks fine because values are not in the range of 10%,20%,30%,40%,50%,60%,70%,80%,90% or 100%
It's crucial for our Dashboards, please help ?
Hi Mahesha_Krishna,
It seems like a known issue about dynamic formatting features to get the wrong values. Power bi team are working on it, and I will update here if any ETA.
Regards,Xiaoxin Sheng
3 Replies
Hi Mahesha_Krishna,
It seems like a known issue about dynamic formatting features to get the wrong values. Power bi team are working on it, and I will update here if any ETA.
Regards,Xiaoxin Sheng
This bug is still existing. I encountered it in my report. when it will be closed?
Mahesha_Krishna , have you considered seaching the current Issues, or contributing a New Issue or as a New Idea. For convienience, the links to these areas of the Fabric Community Forum are listed below.
Issues
If you have found a true bug or issue, you can make a post to the forum to let others know (and that would be very nice of you to do so). But if you want to get it fixed, you should post it in the Issues/Ideas (it varies) area of the community. Specifically, you should post it here:
Power BI - https://community.powerbi.com/t5/Issues/idb-p/Issues
PowerAutomate - https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound
PowerApps - https://ideas.powerapps.com
Ideas
If you have a new idea for functionality or how something should work, you can certainly start a thread on the community to solicit feedback on your idea, but you should also post the idea in the ideas section of the website and solicit others to vote on your idea. The development teams use the Ideas area of the communities to build their development pipeline and a significant amount of weight is placed on Ideas that have lots of votes versus those that do not. The ideas areas of the communities are here:
Power BI - https://ideas.powerbi.com
PowerAutomate - https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
PowerApps - https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
=-=-=-=-=-
If you find this insightful, please provide a Kudo and accept this as a solution.
