Showing results for 
Search instead for 
Did you mean: 

When creating measures off of dataflows or datasets they're always being set to decimal numbers

On the AMA for Arun I asked. When creating a measure in PBI it automatically defaults the measures always to the decimal numbers data type. Since the conditional formatting based on Field Values relies on the Measure to be text is there a way to make Measures always default to a Text data type instead of decimal numbers? They mentioned to submit this to the issues page since it could be an issue in the product.

Status: New
Community Support



You may try adding CONVERT function.

Frequent Visitor



Yes, but as described on the teams call this could be considered a bug as the application should detect the data type. I know we can do the convert step or change the data type manually, but that's an extra step each time that's time consuming if you have a lot of measures.