Forum Discussion

sulin's avatar
sulin
New Member
4 years ago

multiple formatting column in single column

Is it possible to format number and text in a single column? I have data to show % of some cases as number (% format) and if no cases are found then "NA" (which is text format).  I appreciate you he...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

sulin , You need to use format And Switch and create a text measure. Or Create a field parameter (refer video below)

 

example code

Switch(True(),

max(Table[Type]) ="%", format([Measure], "percent", [Measure] )

sulin's avatar
sulin
New Member
4 years ago

Hi Amitchandak,

Thank you for the solution. can you please send the same with example then I can relate with my issue?

 

Thank you,

Sulin

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi sulin 

    >>Is it possible to format number and text in a single column?

    if you put number and text in one column, then the format of this column will be TEXT. Can you provide some sample data and your expected results, so that I can help you further.

    >>I have data to show % of some cases as number (% format) and if no cases are found then "NA" (which is text format). 

    You can try if() function, e.g.   measure=  if(.... , your number, "NA")

     IF function (DAX) - DAX | Microsoft Docs

     

    Best Regards,

    Community Support Team _Tang

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