Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Non empty Format String Expression property in any calculation item destroys % formatting on a chart

When there is (at least one) calculation group in the report with non empty Format String Expression for any item, then some visuals don't work correctly with % formatting.

Chart on the left, stacked column chart with non empty Axis field (Country added to the Axis field), works well. 

And the same chart but with empty Axis field (so there is only one column) doesn't dispaly % values correctly whenever there is at least one non empty Format String Expression property in any calculation item of any calculation group.

avatorl_3-1638998974806.png

"Blue" chart:

avatorl_1-1638998316672.png

"Red" chart:

avatorl_2-1638998327737.png


A .PBIX file with the bug: https://dl.dropboxusercontent.com/s/o5uo5v7vbmz4pal/%25%20Format%20Foramt%20String%20Expression%20in...

 

 

Status: Accepted

Update from PG team:

It is a known limitation for a long time and would be fixed in a couple months.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Accepted

Have submited internal to confirm(ICM: 276940441), would update here as soon as possible if there is any progress about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

v-yingjl
Community Support
Status changed to: Accepted

Update from PG team:

It is a known limitation for a long time and would be fixed in a couple months.

 

Best Regards,
Community Support Team _ Yingjie Li