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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.