conditional formatting

[noviceneil]

Hello everyone,

                                I have a table where both value are percentages are there in the QVD.

I need to show it exactly the same way in the visualization. 

ID            Value                    

A                1504.87

B                 20304

C                 147%

I know that when the ID =C then I need to show it as percentages and otherwise as number. I didn't get any option for row level formatting based on conditions. Is there any workaround? Could you please help.

[Sammy_AK]

your need to use Num function. in your above example, what you can do in your measure is:

Num (sum(value),if(ID='C', '#,##0.00%','#,##0.00')) and set the number formatting to auto or Measure expression.