March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
I create a special format value and visible in the table when , for example, I use a special converter like as:
56.90 EUR/ML
12.91 USD/GWh
those are Text data type, and obviously, works in the table.
But not in the charts, because needs Value format. So I show only
56.90
12.91
but in another measure, because I must to remove format function.
Any idea how to append special chars in the charts?
thanks
Hi,
Have you tried using custom format in the model pane?
Hi, thank you @Gordonlilj
I saw it, but "custom format" is not custom enough, because my format is envolving by another variable. Yes, I know, I didn't tell the detail.
here an example
tag | value | unit |
A | 56.90 | EUR/MWh |
B | 90.10 | GWh |
C | 71.10 | USD/MWh |
D | 61.00 | EUR/ML |
I created measure "converter" and I apply it on the matrix table, calculate and append the format.
When I do it for chart, obviously don't works. So, I transform the measure in value (instead text).
So, can't I manipulate this field?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |