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

How to Create Custom Replicating Rows in Jet Reports

This blog provides step-by step instructions on how to create replicating rows in Jet Reports using the NL Rows function without referencing a table in your database or cube. When working with Jet Global’s Jet Reports, sometimes you need to create replicating rows using the NL Rows function using custom data or combinations instead of… Continue reading How to Create Custom Replicating Rows in Jet Reports

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

Power BI Formatting Issues Resolved

Microsoft Power BI is an amazing tool. It allows me to build reports that update with real-time information from our ERP system, Microsoft Dynamics NAV, so that all of our team members can access information about financials, projects, cash flow, and various statistics in one click. However, Power BI is anything but perfect, especially when… Continue reading Power BI Formatting Issues Resolved

Published
Categorized as Power BI