Skip to content
Home » POWER BI

POWER BI

Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Error handling in Power Query

Power Query is a very powerful tool. It has many inbuilt functions that helps you in data transformation and data preparation. Error Handling allows you… Read More »Error handling in Power Query

 627 total views,  25 views today

Handle NULL values in Power Query

This article demonstrate how to handle NULL values in data. Having null values in data may impact calculations and produce wrong result. As you can… Read More »Handle NULL values in Power Query

 340 total views,  2 views today

Remove matching rows using Power Query

Removing the matching rows or occurrence of specified rows from the table using Power query is very easy as Power Query provides in-built function named… Read More »Remove matching rows using Power Query

 656 total views,  4 views today

Field Parameter in Power BI

Power BI released a new preview feature called Field Parameters in May 2022 update. Using Field Parameters you can dynamically change the measure or dimension… Read More »Field Parameter in Power BI

 1,137 total views,  2 views today

IN operator in Power Query M code

You can check multiple values in any list using IN operator in Power Query. Lets say, you have a requirement to check for specific categories… Read More »IN operator in Power Query M code

 1,416 total views,  1 views today

Ribbon Chart in Power BI

Ribbon chart is used to visualize the data and quickly identify which data category has the highest rank (largest value). Ribbon charts are effective at… Read More »Ribbon Chart in Power BI

 2,566 total views,  2 views today

100% Stacked bar chart in Power BI

Power BI 100% stacked bar chart is used to display relative percentage of multiple data series in stacked bars, where the total (cumulative) of each stacked bar always… Read More »100% Stacked bar chart in Power BI

 2,713 total views,  4 views today