Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Format value works on the table, not in the graph

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

 

2 REPLIES 2
Gordonlilj
Solution Sage
Solution Sage

Hi,

 

Have you tried using custom format in the model pane?

 

2.PNG

Capture.PNG

 

Anonymous
Not applicable

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

tagvalueunit
A56.90EUR/MWh
B90.10GWh
C71.10USD/MWh
D61.00EUR/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? 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.