Forum Discussion

dti's avatar
dti
Frequent Visitor
9 years ago
Solved

Power Bi Service Measures

I am creating a report in Power BI desktop and using various measures. All measures work appropriately on desktop. An example of one of the measures is shown below. It is a direct query to SQL server...
Need Help
  • dti's avatar
    dti
    9 years ago

    I was formatting a column in Direct Query as a decimal number. When I used this column in a slicer, it would cause my measures to stop working in the Power BI Service. Once I changed the column to type 'any', the measures worked. So yes, the problem was solved by changing the column type to 'any' from decimal number.

dti's avatar
dti
Frequent Visitor
9 years ago

I was formatting a column in Direct Query as a decimal number. When I used this column in a slicer, it would cause my measures to stop working in the Power BI Service. Once I changed the column to type 'any', the measures worked. So yes, the problem was solved by changing the column type to 'any' from decimal number.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

dti

 

It is good news that you’ve got it resolved. But it’s really strange, I also tried to add a decimal number column in my database and used it in a slicer. My measure is still working in the Power BI Service.

 

Best Regards,

Herbert