Year Formatting not working in Current Selections Multi-row card

[vishy86]

Hi,

I have a Year field YYYY which I have formatted as Data Type: Whole Number and Format: Whole Number.

I have also kept zero decimal places.

When I use this column in the table report, it correctly shows the Years as 1994, 1995 and so on till 2019.

However, I am also using this column as a report level filter and showing the current selections made using a measure as below - 

IF(ISFILTERED(Year), SELECTEDVALUE(Year, "Multiple Selections"), "No Selection").

In the current selections Multi-row card, the selected Year value appears with 2 decimal places i.e. 1994.00, 1995.00 and so on.

Please help to format it correctly in the Multi-row card.

Thanks,

Vishy

[v-lid-msft · Accepted solution]

Hi @vishy86 ,

We can change the format of measure to whole number to fix this problem.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.