Only function with alternate states & dynamic number formatting

[rnepla83]

Hi community,

I need your help to solve two issue that you can find the explanation of the Problems into the attached file.

Is too long to explain the problem here (is more easy with an attached).

Can someone solve and attach back?

Thanks a lot.

Best regard.

Paolo.

[awhitfield]

Hi Paola,

Question 1.

you could create 2 copies of the table, one with ITA formatting and the second with ENG, an use conditional show set via the 2 buttons

See attached.

Andy

[rnepla83]

Thanks anyway Andrew,

is not possible to follow such way, in my final qvw there will be more than 600 charts, if i will duplicate each object will be 1200 charts to manage.

Impossible

[morganaaron · Accepted solution]

Try this for Issue 2 - haven't extended to try with multiple values though.

[rnepla83]

Really Amazing, ijust have to check if will work with multiple values

Do you have any idea for the issue 1?

Thank you

[rnepla83]

Maybe is better to use the only like that:

=If(GetSelectedCount([Program Description], false(), 'set1') =1, Only({set1}[Program Description]))

or not?

[morganaaron]

Yes - sorry had forgotten that the object wasn't in the alternate state. Unsure about 1, switching the number panel to expression default doesn't seem to allow the interpretation to differ for what the thousand separator is. May be a bug, may just be standard behaviour, afraid I don't know!