Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Year Formatting not working in Current Selections Multi-row card

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

 

 

Need Help
Show and Tell
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    7 years ago

    Hi Anonymous ,

     

    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.

1 Reply

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    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.