Power Query Archives

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PKComments Off

In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard. [caption id="attachment_57629" align="alignnone" width="1920"]

Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021January 31, 2021 PKComments Off

In this article, we have created a dynamic Pivot Table report from multiple tables. We have taken 4 different yearly Sales Table as given in below image- Multiple Sales Table [caption

Power BI

Daily Sales Report – Data Extraction from multiple PDF files

November 15, 2020November 15, 2020 PKComments Off

In this article, we have created a Daily Sales Report (DSR) in Microsoft Power BI. We have extracted and consolidated the data from multiple PDF files using Power Query. After

Charts and Visualization

Dynamic Filled map in Excel

August 23, 2020August 23, 2020 PKComments Off

In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,

Dashboard Power Pivot

Fully Automated Excel dashboard with multiple source files

April 12, 2020April 12, 2020 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power