Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.