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.....
