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.

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

 127 total views,  8 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

 127 total views,  5 views today

Add Saprkline to matrix in Power BI

Microsoft Power BI team has released a December 2021 update. In this update they have added new features and one of the most excited feature… Read More »Add Saprkline to matrix in Power BI

 1,044 total views,  3 views today

Change matrix background color based on value

In this article you will see how to change the background color for specific rows in a matrix based on values in column. Here, we… Read More »Change matrix background color based on value

 1,201 total views,  6 views today

Conditional Column in Power BI

A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI

 1,487 total views,  11 views today

How to show last refresh date in Power BI

Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI

 1,911 total views,  15 views today

Refresh error from changing column names in data source

You may have faced a refresh error when a column name is changed in data source, it happens in such scenario when you have renamed… Read More »Refresh error from changing column names in data source

 3,162 total views,  14 views today

Export Measures and Calculated columns

Documenting DAX formulas is always a good practice as it saves a lot of time in various scenario such as when your PBI report having… Read More »Export Measures and Calculated columns

 4,357 total views,  28 views today

Install and Configure on-premises data gateway

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data basically a data that is not in… Read More »Install and Configure on-premises data gateway

 2,233 total views,  3 views today

OPENINGBALANCEMONTH Function DAX

OPENINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates evaluates the specified expression for the date corresponding to the end of the… Read More »OPENINGBALANCEMONTH Function DAX

 1,767 total views,  6 views today

CLOSINGBALANCEMONTH function DAX

CLOSINGBALANCEMONTH function is a Power BI time intelligence DAX function which evaluates the expression at the last date of the month in the current context.… Read More »CLOSINGBALANCEMONTH function DAX

 2,646 total views,  9 views today