FORMAT bug

Rudz · ‎08-15-2023

How do you report a bug? FORMAT is causing us lots of problems!!!

We have measure like this: FORMAT BUG = FORMAT(68000,"#,##0,,;(#,##0,,);0M")

In our case "68000" is replaced by a measure name that should be formatted as 0, though even 0M would be acceptable. No. It shows 1M. This is beyond wrong and breaking our dashboards. How do I get this reported and fixed?

Idrissshatila · ‎08-15-2023

Hello @Rudz ,

If you want, you can open a support ticket here: https://support.powerbi.com

or you can post an issue here: https://community.powerbi.com/t5/Issues/idb-p/Issues

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

ToddChitt · ‎08-15-2023

Not sure I would use the FORMAT function here. Instead, use the formatting feature of the individual visual element that your measure shows up on. Below are some format options for a Card visual:

Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!