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
Tag: Power BI Drillthrough
Drillthrough report in Power BI
In this article we will look at using Power BI’s Drillthrough functionality using four simple steps. In the Power BI report shown in the screenshots below, I have created two report pages, first page ‘Products’ has ‘Sales Amount by Product Category’ dashboard and the second page ‘Year Comparison’ has ‘Sales Amount by Calendar Year’ dashboard. … Continue reading Drillthrough report in Power BI
Simple SQL BI blogs 