Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Enteries in Query Editor Not Reflected

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 %. ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

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

     

     

    Best Regards,

    Lin

MFelix's avatar
MFelix
Super User
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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?

 

 

  • MFelix's avatar
    MFelix
    Super User
    7 years ago
    You need to select the percentage symbol also on the front end.

    Regards
    MFelix
  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

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

     

     

    Best Regards,

    Lin