Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Different number formatting in same column

Hi PowerBI community,   I know that a column is designed to hold only one data type (and formatting) but wanted to share a use case with you and see if you had suggestions on how to tackle it.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

You can create a meaure

 

 

Measure =
VAR _selval =
    SELECTEDVALUE ( 'Table'[Metric] )
RETURN
    SWITCH (
        TRUE (),
        _selval = "Profit", FORMAT (
            SUM ( 'Table'[Values] ),
            "Currency"
        ),
        _selval = "Efficiency", FORMAT (
            SUM ( 'Table'[Values] ),
            "00%"
        ),
        _selval = "Profit", SUM ( 'Table'[Values] )
    )

 

 

 

https://community.powerbi.com/t5/Desktop/Different-format-in-Target-column/m-p/818394

Regards,

Harsh Nathani

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Harsh,

 

First off, thanks very much as I think I'm close to the solution with this. A couple of questions:

 

. what can I do in the measure for "everything else", ie if I want to control the formatting of 3 specific metrics but I'm ok for the rest to be displayed as they are and don't require further manipulating.

 

. the measure shows data correctly in a card but displays nothing on a bar chart, can you thin of any reason why?

 

. finally, what is the point of the last part of your formula?


Thanks a lot.

OF