cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alice11987
Frequent Visitor

Add suffix to the matrix table

Hi there,

 

I have tried to add suffix "Days" to the matrix table by changing the dataset format to "#,###.00 \D\a\y\s",

but for zero days, it shows as ".00 days"; instead, I would like it to show "0.0 days". 

 

Before: 

alice11987_3-1675734712103.png

 

After:

 

alice11987_1-1675734639476.png

alice11987_0-1675734615337.png

 

Thank you

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @alice11987 ,

 

You need to add the additional place holder for the units try one of the following:

#,##0.00 \D\a\y\s

#,##0.00 "Days" 

MFelix_0-1675780282407.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @alice11987 ,

 

You need to add the additional place holder for the units try one of the following:

#,##0.00 \D\a\y\s

#,##0.00 "Days" 

MFelix_0-1675780282407.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors