Forum Discussion
alice11987
Helper I
3 years agoAdd suffix to the matrix table
Hi, I have the following matrix to show different cycle time. I would like to add "Days" behind each numbers in the matrix.
How can I do it without need to create separate format measure for each of the column?
I would like it to look like this:
thank you
2 Replies
- amitchandak
Super User
alice11987 , Give this format in Measure tools format
#,###.00 \D\a\y\s
or in the property pane model vide
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
- alice11987
Helper I
Hi amitchandak,
Thanks for your help. I have tried with the first option, but for zero days data, it shows as ".00 days". Instead I would like it to show as "0 days":