Bug with format pattern with negative values in Num() function

[maxattar]

Hi, 

I cannot hide the negative sign with a format pattern in the Num function when my bar chart has a condition settled by changing a buttoned variable.

In the Num function, I try to hide the negative sign with the following patterns : # ##0;# ##0' or '0%;0%'

Both does not work (they work when there is no switch button).

The formula : 

If(vSwitchQtéPourcentage='Quantité',
-Num(Count({<[Licencié sexe]={'Femme'}>}[Licencié code]),'# ##0;# ##0'),
-Num(Count({<[Licencié sexe]={'Femme'}>}[Licencié code])/Count([Licencié code]),'0%;0%')

) 

The switch button and the graph are linked.

Sincerely,

Maxattar

[vinieme12]

Ensure you have selected "Measure Expression" under Number formatting

[maxattar]

Hi Vinieme,

Thanks for your help but issue is still up as it was already selected.

[vinieme12]

Can you use two measures instead?

use the show/hide condition to enable disable each

[marcus_sommer]

There is a negative sign before each num() which has not only an impact on the returning values else it will force a new format-evaluation on the results - returning them within the default-formattings as if no num() has been applied.

- Marcus