Data Type is not appearing for Measures.

[PKGR]

Power BI Desktop not showing "Data Type" option, though it shows format option. Please help!

[v-deddai1-msft · Accepted solution]

Hi @PKGR ,

>>thanks for your response, dropdown shows only "text" option after I wrote few calculation groups using tabular editor. 

Calculation group is the root cause. Implicit column aggregations in Power BI are not supported for models with calculation groups. Currently, if DiscourageImplicitMeasures property is set to false (default), aggregation options appear, however they cannot be applied. If DiscourageImplicitMeasures is set to true, aggregation options do not appear.

You can refer to the post: https://community.powerbi.com/t5/Desktop/Tabular-Editor-Calculation-groups/m-p/1283596

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[PKGR]

@negi007 thanks for your response, dropdown shows only "text" option after I wrote few calculation groups using tabular editor. 

[negi007]

@PKGR I am not sure why it is happening to your measure. I have tried similar things at my end and facing no issue. Can you try using INT function like int(5/6) and see if you get other option. Normally text format only comes when value in the measure is in the text format and cannot be converted to integer/number

[negi007]

@PKGR I created the similar measure at my end and I am able to change the data format of the measure like below