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 all,
I have been trying to add a € sign before a value, based on a slicer selection. To do this, I created a measure and used the function FORMAT(x, €#.##). However, it gives me an error.
Can somebody help?
Solved! Go to Solution.
Hi, @dashboard-1 ;
IF you want show in graph, you could create two measures ,because one measure only show one type unless use format. so please try two measures:
Dynamic Display1 =
VAR selectitem =
IF ( HASONEVALUE ( Selector[Type] ), VALUES ( Selector[Type] ), BLANK () )
RETURN
SWITCH ( selectitem, "Cost", SUM ( [Cost] ) )
Dynamic Display2 =
VAR selectitem =
IF ( HASONEVALUE ( Selector[Type] ), VALUES ( Selector[Type] ), BLANK () )
RETURN
SWITCH ( selectitem, "number", SUM ( [number] ), BLANK () )
Then change measure1 type
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @dashboard-1 ;
Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @dashboard-1 ;
IF you want show in graph, you could create two measures ,because one measure only show one type unless use format. so please try two measures:
Dynamic Display1 =
VAR selectitem =
IF ( HASONEVALUE ( Selector[Type] ), VALUES ( Selector[Type] ), BLANK () )
RETURN
SWITCH ( selectitem, "Cost", SUM ( [Cost] ) )
Dynamic Display2 =
VAR selectitem =
IF ( HASONEVALUE ( Selector[Type] ), VALUES ( Selector[Type] ), BLANK () )
RETURN
SWITCH ( selectitem, "number", SUM ( [number] ), BLANK () )
Then change measure1 type
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much! This is working 😀
Hey @dashboard-1 ,
the format itself has to be in quotes.
Try it like this:
FORMAT(x, "€#.##")
Hi,
Thanks for your reply.
I'm trying to convert to a currency when cost is selected at the slicer. The full formula is:
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.