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.
Hello Everyone
I am having some issues with a couple of measures. I am unable to choose the format under "Measure tools". The only option is "Text". When I choose Currency, Percentage or Comma, I get weird data in the Format box.
Measure 1:
It shows "0" instead of "Whole number":
When I try to click the dropdown under format I only see "Text":
Measure 2:
When I click the Percentage sign, I get 0.00%;-0.00%;0.00% in Format, otherwise, dropdown only shows "Text":
The above two measures are in a visual which is displaying the following error. Of note, I do have both of these measures in a duplicate report and they are working just fine, with "% MTD Suborder Change" showing a Format of "Percentage" and "Total Suborder Volume MTD" showing a format of "Whole number" as desired, both of which are unavailable to me now in these two measures. Other measures working fine in this report.
Any ideas how to fix this?
Thank you!
Solved! Go to Solution.
@Anonymous , Have you used the format function on [Total Suborder Volume MTD] or anything which is making it text. I doubt because that is the text you are not getting option in this new measures
If available use this one for both measures
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
Ah Okay I figured it out, I did have a measure on one of the base measures these were refering to that had ISBLANK which caused the issue. I removed and all is good. Thanks!
@Anonymous , Have you used the format function on [Total Suborder Volume MTD] or anything which is making it text. I doubt because that is the text you are not getting option in this new measures
If available use this one for both measures
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
Hello @amitchandak
I have not used the format function and on the Model tab, under Properties > Format they are listed correctly, but whenI look from the Report tab they are not. For example (another one that seems to have just now gotten messed up):
Model tab:
Report Tab:
Trying to customize them does not help, I do not seem to have certain options for these particular measures, such as Data Type, Percentage Format, Thousands Separator, Decimal Places.
I also tried to delete and redo the measures and they are the same.
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 |