Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 like: '0.0 %;-0.0 %;0.0 %' for a percent with 1 decimal and '\$#,0;(\$#,0);\$#,0' for a dollar amount.
My question is, how do I apply that to a number? There has to be a standard function, right?
Thanks
Solved! Go to Solution.
@Anonymous,
Based on my research, you may use valueFormatter module in Formatting Utils.
@Anonymous,
Based on my research, you may use valueFormatter module in Formatting Utils.
@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.
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!
@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?
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |