Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Number Formatting Function

In my custom visual, I'm trying to get the format from a measure. This passes the format of the measure to the ts file:     dataViews[0].categorical.values[0].source.format It produces a value li...
Need Help
abhay03's avatar
abhay03
Helper I
9 years ago

Anonymous,

 

Did you managed to get the formatting in your visual, I am in the exact same situation.

 

I am using the valueFormatter but receiving error "Cannot read property 'valueFormatter' of undefined" in console even for the examples here.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

abhay03

 

I did get it working. This is an example of how I used it:

 

import valueFormatter = powerbi.extensibility.utils.formatting.valueFormatter;

kpiNumber = valueFormatter.create({
                        format: categorical.values[kpiRef].source.format,
                        value: 1001,
                        precision: settings.kpi.decimalPlaces
                    });

kpiNumber.format(kpi)

Good luck!

  • abhay03's avatar
    abhay03
    Helper I
    9 years ago

    thanks a lot @rgodfrey. that helped.

  • satishr's avatar
    satishr
    Helper III
    8 years ago

    Anonymous I implemented your code and it works. However, the formatting doesn't change once the visual is displayed. For example, I have a number formatted as a decimal number with 3 decimal places. My custom visual shows this value correctly when I use it. But if I change the format to Percentage in the Modelling menu, it doesn't reflect. Did you face the same issue?

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      satishr How do you get column format? Do you categorical.values[valueColumnIndex].source.format to get a column format?

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • satishr's avatar
        satishr
        Helper III
        8 years ago

        v-viigYes, I'm using categorical.values[valueColumnIndex].source.format to get the format values. I found out that sometimes this value is not available initially. So I had to put a check for its availability before getting the value. Now it works fine. Thanks