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
I have to dispaly a card with value from a measure but the value comes with decimal which I dont want
Text = "Data Not available for " &[No Data]*100& "% of Entries"
The output Im getting is
Data Not available for 13.35457288383%
Is there a way to limit to the decimal or no decimal so that the result could be
Data Not available for 13% of Entries
Please help
Solved! Go to Solution.
Hi @mahra-in,
Since your measure return the text value, I think you can use format function to formatting decimal number part.
Please take a look at below link to know more about format measure:
Custom Numeric Formats for the FORMAT Function (DAX)
Sample:
Text format = "xxxxx" & FORMAT ( [No Data] * 100, "0.00" ) & "xxxx"
Regards,
Xiaoxin Sheng
The filed No Data is set with 0 in Decimal Places but when I use the field in between text ic omes with many decimal points
still the result is same
Hi @mahra-in,
Since your measure return the text value, I think you can use format function to formatting decimal number part.
Please take a look at below link to know more about format measure:
Custom Numeric Formats for the FORMAT Function (DAX)
Sample:
Text format = "xxxxx" & FORMAT ( [No Data] * 100, "0.00" ) & "xxxx"
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |