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
Category: Power BI
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
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
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
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