Enteries in Query Editor Not Reflected

[Anonymous]

Community,

Can someone let me know how to get the view in the query editor reflected in the model.

For example, if you look at the image in the query editor you will see two columns with %.

However, when I 'apply and save' the % isn't included in the model.

Can someone let me know how make sure the changes in the query editor aren't reflected in the model?

Thanks

[MFelix]

Hi @Anonymous ,

In the case of percentages when you go from the query editor to the "front end" you need to select the columns and on the modeling tab select the format as percentage and it will appear the same as the query editor, believe is due to the fact that the query editor is in M language and the "front end" in DAX so overall the number are decimals but you need to format the view as %.

Regards,

MFelix

[Anonymous]

MFelix,

Thanks for responding. 

As you suggested in the query editor I have selected the column as percentage, see image but the percentage sysmbol still doesn't show in the front end.

Can you let me know wherer I'm going wrong?

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You just need to change the format in Modeling->Formatting in data model

Best Regards,

Lin

[MFelix]

You need to select the percentage symbol also on the front end.

Regards
MFelix