How to Make Measures Total Correctly in Power BI Tables

Microsoft Power BI is a great tool for creating and publishing dynamic and interactive reports, but it has a few quirks that can be tricky to navigate. When creating a Power BI report with a table that contains Measures, sometimes the columns in the table don’t total correctly. When a Measure is used on rows… Continue reading How to Make Measures Total Correctly in Power BI Tables

How to Dynamically Filter in Jet Reports Using a Drop Down-List

This blog provides step-by step instructions on how to create a dropdown list for end users to use to filter a Jet Report without the end user needing Jet Reports license. As a report designer, when working with Jet Global’s Jet Reports, it can be time consuming to create multiple versions of the same report… Continue reading How to Dynamically Filter in Jet Reports Using a Drop Down-List

Navigating and Optimizing Power BI for More Effective Reporting

Microsoft Power BI is a reporting and analytics tool that can analyze data from a myriad of sources, including Microsoft Dynamics NAV, Excel, Google Analytics, social networks, APIs, Odata feeds, and more. Power BI allows for creation of interactive KPIs, charts, graphs, matrices, and other visuals to product unique and meaningful reports you can use… Continue reading Navigating and Optimizing Power BI for More Effective Reporting

How to Set Custom Color Themes in Microsoft Power BI

When publishing internal and external reports for your business it is important to be consistent with your branding standards by using the same color schemes and logos. Microsoft Power BI it a great tool for creating and publishing dynamic and interactive reports and it allows for the customization of colors to match your brand standards.… Continue reading How to Set Custom Color Themes in Microsoft Power BI

Microsoft Power BI Map Visualizations Made Easy

Microsoft Power BI is a powerful tool that allows users to pull real time data directly from Microsoft Dynamics NAV and other sources for analysis and reporting. Included in the analyzation options are two map visualizations that show data by location. These maps are an impactful and creative way to display data. However, sometimes it… Continue reading Microsoft Power BI Map Visualizations Made Easy

Data Visualization: What it is and Why it Matters

Data visualization are tools that present data in a graphical format helping users visualize relationships and patterns. This is especially important when vast amounts of data exist and relationships would be difficult to detect otherwise. Data visualization tools use dashboards which are multilayered data management systems that use data mining and business intelligence to detect… Continue reading Data Visualization: What it is and Why it Matters