Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Rgds
H
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
In format tab change decimal to 0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |