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.
Is there any way we can restructure the whole numbers in Power BI to distinguish the thousands, millions and billions using normal comma operator.
For example: 1,047,890 is represented as 1047890 or 1.04M in Power BI where as I would like it to be represented as 1,047,890. Is there any way we can do that?
There are some options. For example, in Desktop, in the model, if you click on a column and then go to the Modeling tab, you will see that there is a "," button in the Formatting section. Just above it, you can see a "Format:" drop down with things like "Scientific" available. You can always "roll-your-own" formatting (for something like your last example) such as:
= CONCATENATE(TRUNC([Value]/1000000,2),"M")
You might even be able to set the Sort By column for the new field to the original [Value] in order to make it sort correctly.
Edit: For clarity on the difference here between this and @greggyb, if you set it in the model, that should become the default formatting for that field for any particular visual versus on an individual-by-individual basis for each visual, but there are definitely some nice formatting options under the "paintbrush" icon and they seem to keep getting better and more extensive with each release.
You can set display units in the Format menu (paintbrush under the visualizations pane). It defaults to 'Auto', which will choose a unit based on the distribution of values. You can set it to always go to no units. Also make sure to set your display formatting for the measure itself (which will control number formatting when the visual display is set to no units):
Is there such ability for KPI visualization as well to represent numbers. Thanks in Advance
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |