Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |