Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I've been using the new Dynamic String Format feature but have come across some instances where it's not working correctly (or so I think).
My format table is below and my data is linked to this and all works correctly with the backend of things:
However, on the frontend of things (my visuals), some of the formatting doesn't translate very well even when I have selected 'None' on the Value section of the Visual format.
For example the row for the container formatting (#,0 $/container) seems to round up all my values - even when the value is actually say 14,900. Example:
Why is it doing this and how can I fix it? I've tried several different ways of writing out the format string but still no luck. I'm coming to the conclusion that perhaps because its a preview feature it isn't the best to use yet which is understandable.
Any help would be appreciated.
Hi @TotunG,
Any update on this? It should be help if you share some more detailed informations, then we can know more about with your scenario and test to troubleshoot.
Regards,
Xiaoxin Sheng
Hi @TotunG ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 44 | |
| 43 | |
| 33 | |
| 30 | |
| 27 |
| User | Count |
|---|---|
| 134 | |
| 114 | |
| 58 | |
| 57 | |
| 57 |