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
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
Icon for Community Support rankCommunity 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.