Decimal places for measure

[Fusilier2]

Hi,

Is there any way of changing the decimal place formatting for a measure?

I have this measure:

Complaints responded within timescale previous year = CALCULATE(SUM('Complaints  - Number of complaints responded to and within timescale]),SAMEPERIODLASTYEAR('Calendar'[Date]))

I've tried selecting the measure and setting the decimal points to 0 in formatting but it doesn't change.

The red line is the measure:

[v-dineshya · Accepted solution]

Hi @Fusilier2 ,

Thank you for reaching out to the Microsoft Community Forum.

Please follow below steps.

1. created sample data , refer the snap.

2. 

Create a Calendar Table

Calendar = CALENDAR(DATE(2023,1,1), DATE(2024,12,31))
Relate Complaints[Date] to Calendar[Date].

3. Created DAX Measures as per the requirement

% Responded =
DIVIDE(
SUM(Complaints[Complaints Responded]),
SUM(Complaints[Complaints Received])
)

% Responded Previous Year =
CALCULATE(
[% Responded],
SAMEPERIODLASTYEAR('Calendar'[Date])
)

% Responded Previous Year (Formatted) =
FORMAT([% Responded Previous Year], "0%")

4. select the Line and Area Chart

X-axis: Calendar[Date]

Y-axis: % Responded and % Responded Previous Year

5. Data Labels Formatting

In the visual's Data labels pane, try setting decimal places to 0

Please refer the output snap and PBIX file.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @Fusilier2 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Fusilier2 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[v-dineshya]

Hi @Fusilier2 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.

[ryan_mayu]

@Fusilier2 

1. make sure you set up for the correct measure. 

2. you can also try to change the format in the data format

[bhanu_gautam]

@Fusilier2 Try using

Complaints responded within timescale previous year =
ROUND(
CALCULATE(
SUM('Complaints - Number of complaints responded to and within timescale]),
SAMEPERIODLASTYEAR('Calendar'[Date])
),
0
)

[Fusilier2]

Thank you, unfortunately that rounds the values up to 100%