Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have both whole number and decimal values in single column . I want to display as it is (whole number should display same and decimal number should display two decimal places) . But by default it displays always two decimal places even if it is whole number . How do I acheive it ?
Please update any one knows.
Solved! Go to Solution.
You could potentially do something like:
Measure 3 = IF(MOD(SUM(Budgets[Value]),2)=0,FORMAT(SUM(Budgets[Value]),"#####"),FORMAT(SUM(Budgets[Value]),"####.##"))
You could potentially do something like:
Measure 3 = IF(MOD(SUM(Budgets[Value]),2)=0,FORMAT(SUM(Budgets[Value]),"#####"),FORMAT(SUM(Budgets[Value]),"####.##"))
This has work great thank you!
Only issue I have is that is is leaving some of the whole numbers with a decimal point and nothing after it, but not all, see image below. These are whole numbers so a little strange any thoughts?
Works great for the decimal place. Logic is identical to above though have reduced to a single decimal point, though issue occured with 2.
I have got around this issue by adjusting the DAX:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
109 | |
106 | |
90 | |
61 |
User | Count |
---|---|
165 | |
136 | |
134 | |
97 | |
86 |