Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
hi, @Anonymous
You just need to change the format in Modeling->Formatting in data model
Best Regards,
Lin
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMFelix,
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?
hi, @Anonymous
You just need to change the format in Modeling->Formatting in data model
Best Regards,
Lin
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |