• Skip to primary navigation
  • Skip to main content
  • Skip to footer

218.486.5095

Implementation Specialists logo

Implementation Specialists

Microsoft Partner providing ERP solutions, support and consulting.

MENUMENU
  • About Us
    • Careers
  • Industries
    • Contractors
      • Construction Contractors
      • Electrical Contractors
      • Mechanical Contractors
    • Distribution
    • Manufacturing
  • Solutions
    • Dynamics 365 Business Central
    • Dynamics GP
    • Dynamics 365 Sales
    • Dynamics 365 for Financials
    • Power BI
    • Microsoft 365 Copilot
    • wsTOOLS
    • AI Agents
    • BC Apps
  • Services
        • Business Process Review
        • Software Consulting
        • Project Management
        • Technical Consulting
        • Programming
        • System Optimization and Performance Review
        • Report Writing
        • Training for Business Central and GP
        • NAV to Business Central Migration
        • HR Consulting
  • Resources
    • Blog
    • Video Library
    • Webinar Archive
    • Our Partners
  • Events
    • BizCon
    • Webinars
    • Geeks on the Green
  • Contact
    • Support
Home / Online Services

Online Services

Power BI: Getting Started Tips

June 17, 2021

When beginning to use Power BI people tend to get frustrated and some will give up on the process altogether. I did a lot of work in excel and when I started I found Power BI frustrating because it did not function as excel does. With that in mind I have compiled the following list of tips for new Power BI users:

Take time to clean up your data.

When starting most people want to go straight into creating visuals and mapping out their reports. That is ok if you are working from a table that has exactly the columns you need and are titled correctly. If you are connecting to data sources where the information is coming over in a more raw form you definitely want to take the time to clean up your data. Some things you can do:

  • Remove unnecessary columns.
  • Rename columns to be more descriptive.
  • Trim and clean cells to ensure data falls in the correct buckets.
Start with basic reports and then upgrade as you learn more.

While complex, interactive reports may be your end goal I recommend starting with a simple report to learn Power BI functionality. As your experience and knowledge grows you can expand your reports. Start by connecting to just a few tables and add basic visuals.

Pre-plan your reports but remain flexible.

I have found myself staring at a blank canvas in Power BI with a few tables loaded and no idea where to start when creating a report. It is extremely helpful to put together a rough draft of what you want to see before you begin working in Power BI. Draw it out or make a list of the data you want to see, then you can begin collecting and putting the data points onto the canvas. Remember to be flexible as you are creating reports. Space and aesthetics matter so some visualizations may not fit on the same page or you may need to rethink how well it will function for end users. Don’t get frustrated trying to fit a square peg into a round hole.

Ask for help.

If you reach a block and just cannot figure out how to accomplish something or you don’t have the time to familiarize yourself with Power BI ask for help. Consulting companies and the Power BI community are full of experts ready to help make this amazing tool work for you.

-Jerica Coleman, CRM and Power BI Consultant

 

ryan mccollum
Ryan McCollum

Filed Under: Power BI Tagged With: IS Services, Microsoft, Microsoft Power BI, Online Services, Power BI, Power Bi Online

Power BI Formatting: Table and Matrix Visuals

May 20, 2021

Formatting is often overlooked when creating Power BI reports, yet it is something that really elevates a report. I highly recommend spending the time to format or set up a style of formatting reports when you start using Power BI.

To help you on your journey I am doing a Power BI Formatting blog series where we are going to look at different ways you can format Power BI reports.

In today’s example we are going to look formatting options specific to table and matrix visuals.

Here is our current matrix visual with default formatting:

Formatting options are available by selecting the paint roller icon on the visualization tab.

  • Style
    • This allows you to select between pre-defined formatting for your visual.

  • Grid, Column headers, Row headers and Values
    • If you do not want to use a preset style you can use these four areas to design your table style.
    • In the below example I turned on the vertical grid and formatting the color and thickness of both the grid and outline. I formatted the column and row headers to be framed in by the outline, gave the column headers a center alignment and increased the stepped indentation for the rows. I removed the +/- icons from the row headers and changed the font color for the alternating rows.

  • Subtotals
    • Subtotals can be turned off if you do not want the different categories to sum the details. If you have subtotals turned on you can also set them per row level and determine which levels you want to total.

  • If you have columns on a matrix visual, you will also have the option to turn on subtotals for the different columns.
  • Grand total
    • Turning this on will give you the total line that appears at the bottom of your table/matrix. We also accomplished this with the row level subtotals by having it turned on at the top row level.
  • Field formatting
    • If you want just one column to be formatted differently you can apply field formatting and change the font, background and alignment. This can be applied to the values, header and totals. If you want to set this up you do need to format each column individually.

  • Conditional formatting
    • Like field formatting conditional formatting is done by individual column and you can set up the column to format based on a color scale, field value or rules. The background and font colors can be changed, data bars can be added or icons can appear. The fields used for formatting do not need to appear on the visual.
    • In the below example I set the color of the job name font to be defined by the field value of a custom column created that labels a job green or yellow depending on whether the original contract amount is over or under $100,000. Icons were added to the total revised forecast cost depending on a set of rules where measures were used to calculate the percent of revenue based on forecasted cost compared to the original contract amount. Finally, data bars were added to the total actual cost column to easily see which jobs have cost the most.

  • For more information on how to set up conditional formatting see a previous set of blog posts regarding conditional formatting.

Although I don’t expect anyone to use all the formatting options available for each table or matrix visual I hope this has helped you see some of the options available to use. Don’t be afraid to play around with formatting. If at any time you do not like what you have done you can always select the “Revert to Default” option at the bottom of any area and the visual will revert back to default settings.

– Jerica Coleman, CRM and Power BI Consultant

ryan mccollum
Ryan McCollum

Filed Under: Power BI Tagged With: IS Services, Microsoft, Microsoft Power BI, Online Services, Power BI, Power Bi Online

Power BI Formatting: Interactive Filters (Slicers)

May 4, 2021

Formatting is often overlooked when creating Power BI reports, yet it is something that really elevates a report. I highly recommend spending the time to format or set up a style of formatting reports when you start using Power BI.

To help you on your journey I am doing a Power BI Formatting blog series where we are going to look at different ways you can format Power BI reports.

In today’s example we are going to look at formatting slicers, which is Power BI’s interactive report filters.

Text Slicers

When you select a field to be a slicer it will default to a list type filter.  Here is an example of a slicer for vendor class in our report.

Let’s review the formatting options available when you select the paint roller icon. We are only going to review options that are specific to slicers.

  • General
    • Orientation: Switch between vertical and horizontal to make the list items appear like buttons.

  • Selection Controls
    • Single select
      • Turn this on if you want users to only be able to select one value from the slicer at a time.
    • Multi-select with CTRL
      • Defaults to on. Turn off if you want users to be able to select multiple values without needing to use the CTRL button.
    • Show “Select all” option
      • Turn on if you want a select all option. I generally do not use this as clearing out all selections from your slicer defaults to showing all.
    • Slicer Header
      • If you turn the header off you will lose the clear and list options available in the visual, so I do not recommend turning it off. You can change the header text here to give the slicer a different name.
    • Items
      • Here you can set the color and text formatting for the values displayed in the slicer.

Within slicers you can also change a few things by selecting the down arrow or ellipsis located in the upper-right hand side of the visual itself.

  • Down Arrow
    • Change between list and dropdown style.

  • Ellipsis
    • Add a search box to the list if you have a larger set of data.

Date and Number Slicers

There are a few different options with date and number slicers. We are specifically going to look at date fields, but it’s helpful to know that number slicers will have most of the same options.

Date Format

When you select a date field for a slicer it defaults to using the date hierarchy, which will provide a list to choose year, quarter, month and day.

If you want to only select between year and month you can remove quarter and day by selecting the x next to that data value in the visualization pane.

If you want to be able to search between specific dates you can switch from using the document hierarchy to the actual document date by selecting the down arrow next to your date field on the visualizations tab.

When you select this date format there are a few more options available to you from the down arrow within the visual itself.

  • Between
    • This is the option shown in the example above and allows you to set your beginning and end date.
  • Before
    • Looks the same as the between option but greys out the first date box so you only have to enter the end date.
  • After
    • Looks the same as the between option but greys out the second date box so you only have to enter the beginning date.
  • List
    • This lists all dates available as we saw in the text slicer.
  • Dropdown
    • Keeps all dates listed but is formatted as a dropdown box to save space.
  • Relative Date
    • Allows you to search within a time period specific to today, such as the last 7 days or the next 2 years.

  • Relative Time
    • Similar to relative date but allows you to look at hours and minutes.

There are a few differences in what is available on the formatting tab when you select the paint roller as well.

  • General
    • There is no option to switch between vertical and horizontal.
  • Slider
    • With the between, before and after options a slider bar will appear. If you do not want to use the slider bar you can turn it off.

Although slicers are a cool interactive feature for your end users I do find that formatting is important for saving space on your reports and making it easy for end users to navigate the report.

-Jerica Coleman, CRM and Power BI Consultant

ryan mccollum
Ryan McCollum

Filed Under: Power BI Tagged With: IS Services, Microsoft, Microsoft Power BI, Online Services, Power BI, Power Bi Online

Power BI Formatting: Page Formatting

April 19, 2021

Formatting is often overlooked when creating Power BI reports, yet it is something that really elevates a report. I highly recommend spending the time to format or set up a style of formatting reports when you start using Power BI.

To help you on your journey I am doing a Power BI Formatting blog series where we are going to look at different ways you can format Power BI reports.

In today’s example we are going to look at page formatting.

All these formatting options are available when you select the paint roller icon from the visualization tab with NO visuals selected.

If you have a visual selected it will access the formatting options for that individual visual versus the page itself.

Page Size

There are a few different size options available. If you are viewing reports on the Power BI desktop or Power BI online there is no need to switch sizes, but if you plan to export reports different sizes could be beneficial.

  • 16:9
    • This is the default size.
  • 4:3
    • A smaller canvas size that fits less visuals.
  • Letter
    • Switches the report canvas to a portrait orientation versus the default landscape orientation. This would help if you intend to export to a PDF that you would want to print.
  • Tooltip
    • Allows a set of visuals to be placed on a page that will appear as a tooltip on other pages of the report. We will look more into tooltips in a future blog post.
  • Custom
    • Set a custom canvas size.

I usually use the default 16:9 and tooltip sizes when creating reports.

Here are examples of the 16:9, 4:3 and letter size canvases.

Report canvas backgrounds can be customized with a specific color or image and transparency level. Use a higher transparency level to either fade a color or create a watermark effect with an image. Colors can be chosen from the default set or customized using the HEX color or RGB definition.

When working with a page background remember that visuals also have a default background, to see through to the page background individual visuals must have their background turned off or set to 100% transparent.

In the below example we have given our report a 50% transparent grey background. The top two visuals also have their backgrounds set to allow the background to show.

Page Alignment

Choose between top or middle alignment to determine how the report canvas is aligned on the screen.

Wallpaper

The options are the same as setting a page background, but this affects the entire visible screen versus just the canvas portion where visuals are placed. It is extremely helpful if you want to layer an image and color on your background.

In the below example a picture was added to the page background and set at 75% transparency and a grey was set as a color wallpaper. The grey is lighter where the visuals appear because the background of the picture was white and it combined the two colors to make a lighter grey

Filter Pane and Filter Cards

With these formatting options the filter pane appearance in both color and font can be customized. Here is an example of a report with a filter pane that has been customized.

I have not run across a lot of desire to custom this pane as it seems a bit extra, but it is a cool option if you want to give the whole report a streamlined look.

-Jerica Coleman, CRM and Power BI Consultant

 

ryan mccollum
Ryan McCollum

Filed Under: Analytics, Power BI Tagged With: IS Services, Microsoft Power BI, Online Services, Power BI, Power Bi Online

Power BI Formatting: Changing Field Names and Summarization

April 9, 2021

Formatting is often overlooked when creating Power BI reports, yet it is something that really elevates a report. I highly recommend spending the time to format or set up a style of formatting reports when you start using Power BI.

To help you on your journey I am starting a Power BI Formatting blog series where we are going to look at different ways you can format Power BI reports.

In today’s example I want to create four separate charts based on the sales invoice type to track the average amount of quotes, orders, invoices and returns by country.

I started by connecting to my sales table and then created four different visuals showing document amount by country. I applied a filter to each visual by sales transaction type for each of the categories I want.

Here is what my visuals looked like:

 

The problem is we cannot distinguish which visual is showing us which sales transaction type unless we look at the filters pane and it is currently showing us the total of all document amounts.

I need to identify what each of the charts is showing and change the data points to show as averages versus totals.

Changing Field Names

There are a few different ways you can change a field name.

  • Rename the column in Power Query.
    • This will change how the field name appears in your field list and is helpful if you have an obscure schema name that you may not understand what data it contains. (Example: Changing column DCDT to Document Date)
  • Rename the field on the fields pane.
    • This has the same effect as renaming a column in Power Query as it affects how the field appears in your field list. This is helpful if you want to change how the field appears in multiple visuals that will use the same verbiage.
  • Rename the field for an individual visual.
    • Sometimes you do not want to change from the schema name so you can trace back exactly where the data is coming from in the data source or you may not want all visuals to use the same verbiage. In these cases renaming a field for an individual visual is the best option.

For my report I am going to rename the field for each individual visual as they all contain the same fields but because of filtering I want them to be worded differently.

To rename the field select the down arrow next to the field you wish to change on the visualizations pane. From the box that appears select “Rename for this visual”.

Here is how my visuals looked after renaming the fields:

You can see that both the axis and title have changed to reflect the new verbiage. Now I need to update the visuals to show averages versus totals.

Changing Summarization

Each field contains a default summarization and that is what visuals will show when first created.

  • Change the default summarization.
    • Use if most of your visuals will need a different type of summarization to avoid having to change each visual individually.
    • With the field highlighted in the fields pane select a summarization within the column tools tab.

  • Change the summarization for an individual visual.
    • Use if you want the data to appear differently just for one visual.
    • On the visualizations pane select the down arrow next to the field you want to update. (This is the same area we were in to change the name on an individual visual.)

As I only want to show these four visuals as averages I chose to change the summarization at the individual visual level. Here is what my visuals look like now:

Although this looks like the last picture we know now that the data points are showing us average amounts versus total amount.

I hope you enjoyed today’s formatting examples. Stay tuned for future blog posts on other ways you can format your Power BI reports.

-Jerica Coleman, CRM and Power BI Consultant

ryan mccollum
Ryan McCollum

Filed Under: Power BI, Uncategorized Tagged With: IS Services, Online Services, Power BI, Power Bi Online

CRM: Working with Accounts

March 24, 2021

Accounts are a foundational entity within Dynamics 365 Customer Engagement, so it is extremely important to understand how to work with accounts.

Accounts are one of the entities that will appear across any of the Customer Engagement apps that you have purchased. They also come with a parental hierarchy out of the box, which means any activity on an opportunity, case, or project will be visible on the account page as well.

Let’s review some account basics.

General

Accounts are designed to be organizations that you work with, whether they are customers, vendors, partners, competitors or anything else you want to track in CRM.

Parent Accounts

Parent accounts allow you to set-up a hierarchy within accounts. This is helpful with companies that have multiple locations.

  • Parent accounts can have multiple child accounts.
  • Create parent accounts first and then create the child accounts with the name of the parent account placed within the parent account field.

Relationship with Contacts

Contact records are individual people that can be related to an account. An account can have multiple contacts associated with it. To associate a contact to an account, place the account name in the company section of the contact record.

A primary contact for an account can also be identified. Select from the list of associated contacts that have been created.

Configuring Default Fields

There are quite a few default fields available out of the box that are option sets ready to be configured. Generally, I do not recommend using all of them as a few can overlap on usage. Let’s review them and identify some common uses.

  • Account Rating: Identify high priority customers or give your accounts levels of importance.
  • Business Type: Use instead of industry if you want a smaller option set or use to identify what they may want from you.
  • Category: Use to identify relationship you have with an account.
  • Classification: This is another way you could identify high priority customers or levels of importance.
  • Industry: A default list is within the system, but you can change, add or delete the list to fit the industries you want to see.
  • Relationship Type: Identify if an account is a customer, vendor, partner, competitor or other type of relationship.

Customizations

Beyond the basic set-up there are a few things you can do to make the account entity work better for you.

  • Forms
    • There are a lot of default fields available that are not on the out of the box forms. Take some time to custom the form and add-in some of those other fields that you will want to use.
  • Custom Fields
    • If you have more data that you want to enter within the system that are not available out of the box you can create a new custom field. Custom fields can be simple entry or calculated based on other fields within the form and can include option sets, date and time, numbers or text entry.

Accounts are a high priority when setting up your CRM system and generally one of the first things you begin entering. I highly recommend spending some time reviewing what is available out of the box and comparing that to the data you want to track to determine what needs to be configured, what needs to be created and how you want the form to look.

-Jerica Coleman, CRM and Power BI Consultant

 

ryan mccollum
Ryan McCollum

Filed Under: CRM Tagged With: CRM, IS Services, Online Services

  • Page 1
  • Page 2
  • Page 3
  • Interim pages omitted …
  • Page 7
  • Go to Next Page »

Footer

We provide complete solutions for your business challenges.


920 O’Donnell St
Hawley, MN 56549

p. 218.486.5095
f. 218.486.5094

Connect With Us

  • Facebook
  • LinkedIn
  • YouTube

Our Solutions

  • wsTOOLS
  • Dynamics 365 for Financials
  • Microsoft Dynamics GP

Our Services

  • Business Process Review
  • ERP Software Consulting
  • Programming
  • Technical Consulting
  • Project Management
  • Report Writing
  • System Optimization & Review

Our Company

  • About Us
  • Testimonials
  • Careers
  • Contact Us

Our Resources

  • Resources
  • Blog
  • Events
  • Support

Join Our Mailing List!

  • This field is for validation purposes and should be left unchanged.
Copyright © 2026 Implementation Specialists | Privacy Policy | Terms of Service | Site Credits