Dynamically Change Format In Visual

[Anonymous]

I'm confused on how to use best practices with a slicer.   I want the users to essentially be able to choose Units or Sales in a slicer where Key is selected for Slicer.   This would then flow thru to a visual that would be a bar chart with a yoy line.   I can create the yoy measure for both, so thats not the issue.   However, the problem I'm having is that sales is in dollars and units is not.  I have my data structured like this:

Company	Date	Key	Value
Company A	Nov-19	Sales	$12.50
Company A	Dec-19	Sales	$15.50
Company A	Nov-19	Units	2
Company A	Dec-19	Units	4
Company B	Nov-19	Sales	$20.50
Company B	Dec-19	Sales	$25.00
Company B	Nov-19	Units	4
Company B	Dec-19	Units	5

Is it really not possible to dynamically change the format in a visual?  

Has this been solved? 

https://community.powerbi.com/t5/Desktop/Dynamically-format-a-measure-as-or/td-p/157192

Thank you in advance

[parry2k]

@Anonymous you can sure use but it will be string

Sum = 
VAR __selectedValue = SELECTEDVALUE ( Table[Key] )
VAR __sum = SUM ( Table[Value] )
RETURN
IF ( __selectedValue = "Units", FORMAT( __sum, "General Number" ), 
FORMAT ( __sum, "Currency" 
)

[Anonymous]

thank you - but as you mentioned it is a string, so you can only put it in a tooltip.  

So does this mean there is no way to dynamically change the format in a visual?   

And if not, can we remove the Value from the tooltip so all it sees is the string?

[parry2k]

@Anonymous correct, you cannot use it in visual like bar chart etc but you can surely use it in Card Visual, Yes you can use it in tooltip, and to remove actual value from tooltip, you can create custom tooltip page that allows you to choose whatever you want to show on tooltip

[Anonymous]

that's crazy you can't dynamically change formatting on a visual.  such a basic feature.  thanks though.

[v-jayw-msft]

Hi @Anonymous ,

I sincerely invite you to submit your idea if you want:

https://ideas.powerbi.com/.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.