Forum Discussion

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

Having trouble with options.dataview model

Hi all,

 

FYI- trying to get a custom table visual in PowerBI.

I'm fetching data from a excel sheet in powerBI service. My data sheet has some columns which contains numbers only and 1 column has data in format like "$1" or "$2".

anycguy
56$7
32$1
667$7
59$7
123$1

 

when fetching data from table, I'm using options.dataview[0].

The thing is -> in dataview i can only see numbers of "guy" column like 7,1,7,7,1. No dollar sign is there

so when trying to print the same in table visual. It's just a number with no $ sign. but I want that sign too followed by number.

Need help.

Need Help
  • v-mubish's avatar
    v-mubish
    9 years ago

    Hi v-jiascu-msft,

     

    No, I developed my own. but now the problem is solved after using valueFormatter utility in my code.

     

    Thanx for help anyway.

     

    Regards,

    Mukul

6 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi v-mubish,

     

    You can add them in the Modeling ribbon. Please have a try.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi v-mubish

       

      Did you try creating the report after deleting it? Which custom visual do you use?

       

      Best Regards!

      Dale

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

        HI v-jiascu-msft,

         

        Reflection of changes done in modelling pane is happening without saving any report, and I am using custom table visual which is currently in development.

         

        Regards,

        Mukul