Category: Power BI

The Best Data Type For A Calendar Table In Power BI

The Best Data Type For A Calendar Table In Power BI - Enterprise DNA

Using a calendar table in Power BI allows you to filter your reports by time intelligence attributes like Year, Quarter, Month, and any other time aggregation using non-standard columns that your organization might need. In this tutorial, I’m going to talk about some considerations related to the calendar table, more specifically on what data types are

Continue reading

Best Power BI Dashboard Design Tips

Best Power BI Dashboard Design Tips - Enterprise DNA

Creating effective and visually appealing Power BI reports is essential for communicating data to stakeholders. However, designing a Power BI report can be a challenging task, especially when trying to balance aesthetics and functionality. In this blog post, we will discuss the best Power BI dashboard design tips that will ensure that your information is

Continue reading

COALESCE Operator: Power Query Application

COALESCE Operator Power Query Application Enterprise DNA

This tutorial will demonstrate how to use the COALESCE operator in Power Query / M language by examining two practical problems. You can watch the full video of this tutorial at the bottom of this blog. The COALESCE operator is represented by a double question mark (??). This operator works similarly to the or operator

Continue reading

Power Query Transform Column Challenge: Stacked Data to Ordered Table

Power Query Transform Column Challenge Stacked Data to Ordered Table - Enterprise DNA

This blog will examine the Stacked to Ordered Data Challenge from Excel BI, involving the Power Query transform column to table functions. The task is to turn a single column of data into a proper table where each type of data has its column and subsequently will add a rank on population. You can watch

Continue reading

Introduction To Creating An SSRS Bar Chart

Introduction To Creating An SSRS Bar Chart - Enterprise DNA

Bar charts are a popular way of visualizing data and are often used to compare data across different categories. In this tutorial, you will learn how to create a bar chart using SQL Server Reporting Services (SSRS) for your paginated reports. We will use a sample paginated report with matrix showing the Quantity and Sales

Continue reading