Forum Discussion

Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago

M Query filter on Value.FromText

So I have a column that I can't change to number but need to filter based on value.   I used the advanced editor to do this and it seems to work in preview, the "values" start where I want, but fai...
Need Help
Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago

Removing the filter does "fix" the error.

 

 

The data on the source system has not changed.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Aron_Moore,

 

It seems to be that the issue is related to the measures. Could you share a sample pbix file(with just some dummy data) which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards