Help! Need help with rounding in stacked bar charts

[Sara16]

Hi Power BI Team

Just reaching out for some guidance or assistance on rounding in a stacked bar char

I have built measures for the bar chart (same for neutral/ yellow and negative/ red) DAX Below

Positive =

CALCULATE(

    COUNTA('Demographic Data Transposed'[Value]),

    'Demographic Data Transposed'[Value] IN { "Strongly agree","Agree" }

)

Most of my bars = 100% but as you can see from below, there are some that do not add up (highlighted) 

Is there any way I can fix the rounding or even change the rounding from 2 percent (currently) to 1 percent. I tried to change in Measure Tools or via the Data view but nothing seems to work 😞 

Thanks in advance 

[Sara16]

the percentages are based off a measure - the measure table makes no difference so hoping there might be some dax code to assist

[Sara16]

Hi @amitchandak 

Unfortunately none of these worked - is there any other workaorund to get the stacked to = 100%

[amitchandak]

@Sara16 , After you fix from measure tool , remove and add measure again to stacked visual and try

or at visual level check format

[Sara16]

Hello

Stil unfortunately doesnt fix the issue of rounding to 100% - some bars equate to 101% where as others are at 99%. Is there any kind of workaorund for this? 

Thankyou

[Sara16]

Thankyou for the quick response. Unfortunately didnt work. Changed to 1 decimal, removed and re added back to the visual and nothing (likewise for visual itself) - is there another work around?