Restrict the values to two decimals

[ajsjoshua]

Dear all,

When I hover a chart the values should be integer or fixed to 2 number.

In my expression i formatted the number as auto and checked the value on data points and it displays the values in millions but when i hover it shows all decimals.

PFA for screenshot.

Regards,

Joshua.

[prma7799]

Have you tried this with your expression

Num(Sum(Sale), '##.##')

Or please share sample app

[ajsjoshua]

Hi PM,

When we use this Num(Sum(Sales), '##.##') and hover the chart it shows sales value 3 times

like sales:276.2 M

sales:276358049.82

sales:276358049.8199878

[prma7799]

Please share sample app.

[francescoreggia]

try

round(Sum(Sales),0.01)

[OmarBenSalem]

U have  expressions; maybe the revenue one is mis formatted

format it as a number

[ajsjoshua]

Hi PM

PFA for sample app.

when we hover it should show only one sales.Here in this sample it will show two sales.

[OmarBenSalem]

Name the label of your color by measure EXACTLY like the label of ur measure.

result:

If they're not named exactly identical:

example:

It will show it 2 times even if it's the same measure u're using in both measure and color by measure (sum(Sales)):

[ajsjoshua]

Hi Omar,

Thanks for ur reply.

Even if i name same label to both expression still it shows sales two times.