cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henrik_99 Regular Visitor
Regular Visitor

Remove zero digits

Hi

 

Have both whole number and decimal values in single column . I want to display as it is (whole number should display 1 and decimal number should display 0,5)

 

 

Column = SWITCH(TRUE();TABLE[FROM DATE]=TABLE[Active Date];0,5;TABLE[TILL DATE]=TABLE[Active Date];0,5;ROUND(1;0))

 

 

Untitled.png

 

Rgds

 H

2 REPLIES 2
Highlighted
adityakommu Member
Member

Re: Remove zero digits

In  format tab change decimal to 0

Community Support Team
Community Support Team

Re: Remove zero digits

hi, @Henrik_99

     After my research, I'm afraid it couldn't achieve in Power BI for now.

when you set the format and this whole column will have the same format.unless you set the format is Text.

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

 

 

Best Regards,

Lin

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