-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Building Dashboards with Microsoft Dynamics GP 2016
By :

If we asked you if your data was clean and organized, you would probably say yes. However, data usually always has issues. For example, in a field for State, some users could enter NY
and some could enter New York
, along with a lot of other variations that include N.Y.
, N. York
, and more. If the state of New York is spelled out in just these four ways, that is four separate entities as far as your computer is concerned. Your machine does not have the capacity to interpret the meaning, only exactly what is entered, even though you may occasionally think the computer hates you.
One of the tools that Power BI Query Editor has that helps with this kind of situation is the Replace Values feature. This feature is similar to Find and Replace in Excel. Let's see how this works now:
Vendors
query in the Queries pane.Change the font size
Change margin width
Change background colour