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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
Trying to develop custom table visual. my input dataset looks like this -:
| Hours | header1 | header2 | header3 | header4 | header5 | header6 |
| 8:00 AM | 0 | 1 | $0 | 0 | 0% | 0 |
| 8:00 AM | 2 | 0 | $2 | 2 | 0% | 2 |
| 9:00 AM | 1 | 0 | $1 | 1 | 1% | 0 |
I am trying to add the symbols i.e. $ and % at last while printing the particular element of column "header3" and "header5" (prefixing or suffixing the symbol before/after data), based on the format these columns are giving in options.dataview
format for % is-: "0%"
format for $ is-: ""$"#,##0;\("$"#,##0\)" (idk, looks like regular exp)
So trying to prefix and suffix the symbol based on diff. conditions.
Working in PowerBI service nicely but when i am paackaging it and running in Power BI Desktop, It is appending $ sign with each cell's element in table.
Not sure if, format is getting changed for table columns in dekstop version.
A helping hand is appreciated.....
Topic looks like duplicate of this topic.
Please take a look at that topic to find out more.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Sorry, Ignore this one.
Thank you.
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!