Showing % and numbers in the same column

[Anonymous]

Hey guys, 

I would like to show numbers and % in the same column in powerbi. Is this possible? For example I have these two metrics: 

Sales volume A = 100,000 ( for demonstration purpose) 

and share of market A = 2.6% 

Now I would like to show both these in the same column in formats 100,000 and 2.6%. 

Is this possible? 

Please help.. 

Thanks,

Ash

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could use FORMAT() to create a measure like this:

Measure =
VAR _value =
    MAX ( 'Table'[Column1] )
RETURN
    IF ( _value <= 1, FORMAT ( _value, "#.0%" ), FORMAT ( _value, "###,###" ) )

But it returns Text not Number.

If you want a measure can be used to toggle what appears on a chart so that the end user can easily switch the data being visualised,please refer to this blog:

Dynamic Formatting of Switch Measures - Excelerator BI

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

[Anonymous]

Amazing Eyelyn9, your method works like a charm. Thank you so much! 

[amitchandak]

@Anonymous , You can create a measure like this and try

divide(sum(Table[Volumn]), calculate(sum(Table[Volumn]), allselected(Table)))

or their is a % of total option using measure on right click in visual pane, you can use that and change visual.

refer: https://www.youtube.com/watch?v=6jTildcV2ho