Values & Percentages within same field

[ked05a]

I currently have a table the has a list of service lines and a column for metric value. My issue is some service lines require % and some service lines require values. How do I format my table/visual to display the correct format?

Example Data

Service Line Value
Service 1 1,250
Service 2 .75
Service 3 385
Service 4 .05

Thanks,
Kevin

[sam.mckay]

Check out this forum thread

Different formatting types for two switch outcomes

Fellow Power BI Users - I have been working through the module for multi measure dynamics and have come across a problem. I have two slicers working from switch statements and have combined them. One selects dollars or units and the other selects viewing the outcome as a percentage or an actual value. It is the second switch I am having trouble with - I can only format to see the result as either numbers OR % - I do not see how to say ‘in situation A show me the number, in situation B convert …

This is really the only way to complete something like this right now.

See if you can apply the technique to your report

[kaycee]

Hi @sam.mckay , just wanted to check if you’ve seen any improvements in this area?

It is a common request to have a Gross Profit % built into my clients’ reports or a Contribution Margin below the associated $$. Using the FORMAT option for this one row compromises performance hugely. I keep thinking I can’t be the only person preparing ‘traditional’ finance reports and facing this issue!

I can put it in a separate table but the order of rows often makes that a shocking alternative.

Thanks in advance.