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 |
---|---|
119 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
104 | |
102 | |
89 | |
66 |