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.
Hi there,
is there a possibility to customize the numbers in a visual like for example: 81 abc ?
I´m looking for an equivalent in excel: #.##0,00 "abc"
I´m only able to model the figures in the pre-set formats like currency etc.
Thanks in advance
Felix
Hey,
I Know that this in not exactly what you want, but
you can use a measure like this:
--> create new measure.
--> type
yourMeasure = sum(Table1[Column1]) & "abc"
Thanks for your suggestion,
but as you mentioned I´m looking for a directly visible unit
Try using both format and concatenate at the same time
FORMAT(<Value to be formatted>,<Format Pattern>) & " " or
CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))
Not sure how to use your formula.. I´m not into DAX. Does it runs with a new Measure or where is the formala to put in?
Clik right on the left side "Field" and select new Measure, or find button in ribbon menu.
I did this already. The result is the following:
But my aim was to get the unit within the chart.
Ok, right now there is no built in function in PBI for this.
Check if this can help you:
greetings,
Wolf
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |