Category: Power BI

Most common methods to Filter the Power BI visualization

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. This post will discuss on the five most common methods to filter the Power BI visualization. For the demonstration, I have created one bar chart which displays Sales Amount by Product Category, one pie chart which is … Continue reading Most common methods to Filter the Power BI visualization →

Edit Interactions between Power BI visualizations

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. To demonstrate on how to control the interactions between two visualizations, I have created one bar chart which displays Sales Amount by Product Category and the other visualization is a pie chart, which is distributed according to … Continue reading Edit Interactions between Power BI visualizations →

DAX formula to obtain the count from SCD type-2 dimension records

Data source used for this post is the ‘Reseller Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server data warehouse. The ‘DimEmployee’ table in the data mart is clearly a SCD type-2 dimension, which means any update to the employee record is created as a new row with a new start date and the old employee … Continue reading DAX formula to obtain the count from SCD type-2 dimension records →

Customer retention over the years using DAX in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. In this post, we will write and use DAX formulas to get the customer retention count when compared with last year and when compared with all the previous years. In addition, we will also look at testing … Continue reading Customer retention over the years using DAX in Power BI →

Ranking using DAX in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. In this example, let’s look at ranking Countries and States individually according to the sales and then ranking Country and State fields when grouped together. For ranking, RANKX function is being used. RANKX function helps to provide … Continue reading Ranking using DAX in Power BI →

Color-code Visualizations using Grouping in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. Grouping clearly helps to better visualize and analyze our data. In this example, we will look at grouping the field values and use them to format the color of the visualizations. Let’s look at the steps involved … Continue reading Color-code Visualizations using Grouping in Power BI →

Dealing multiple date relationships with the fact table in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. During the data modelling in Power BI, although one could create multiple relationships between two tables, enabling a second relationship as ‘Active’ raises an error. Therefore, it could become difficult to measure the fact data in terms … Continue reading Dealing multiple date relationships with the fact table in Power BI →

Candlestick visualization in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. A Candlestick graph requires four values, namely Open-Close-Low-High for each time period that is being compared.  For this demonstration, will look at creating the Candlestick visualization that compares a calendar year month-on-month sales on the first day … Continue reading Candlestick visualization in Power BI →