Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Comments
v-chuncz-msft
Community Support

@cvillegas 

 

You may try adding CONVERT function.

cvillegas
Advocate IV

@v-chuncz-msft 

 

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.