Forum Discussion

v-mubish's avatar
v-mubish
Icon for Helper I rankHelper I
9 years ago

Different behaviour of Custom Visual in power BI Service and Desktop

Hi,

 

Trying to develop custom table visual. my input dataset looks like this -:

Hoursheader1header2header3header4header5header6
8:00 AM01$000%0
8:00 AM20$220%2
9:00 AM10$111%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.....

 

2 Replies

  • v-viig's avatar
    v-viig
    Icon for Community Champion rankCommunity Champion

    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

    [email protected]