Skip to content
Home ยป Power BI Tutorial

Power BI Tutorial

Power BI Tutorial Power Bi Reports, 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.

Replace multiple values in one column Power Query

Power Query allows you to replace any values with new values, you might have used power query replace values option which replace the old value… Read More »Replace multiple values in one column Power Query

 907 total views,  14 views today

Difference between PBIX, PBIT and PBIDS file format in Power BI

A PBIX, PBIT, and PBIDS are file extensions used in Microsoft Power BI. Lets explore and see the difference between each of them one by… Read More »Difference between PBIX, PBIT and PBIDS file format in Power BI

 891 total views,  7 views today

Remove duplicate and keep latest record in table

In this article we will see how to remove duplicate record and keep the latest record in table using Power Query. As you can see… Read More »Remove duplicate and keep latest record in table

 344 total views,  1 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,135 total views,  2 views today

Creating Dynamic Title based on Slicer Selection

You can create a dynamic title based on values selected in slicers or can show slicer selected values in text box. Lets create a dynamic… Read More »Creating Dynamic Title based on Slicer Selection

 639 total views

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,554 total views,  11 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,703 total views,  4 views today

Power BI November 2021 update

Microsoft Power BI team has recently released November updates such as page and bookmark navigators, new format pane preview feature, sort legend, new text box… Read More »Power BI November 2021 update

 1,630 total views,  1 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

 3,010 total views,  3 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

 3,135 total views,  4 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

 5,012 total views,  5 views today

Refresh error from changing column names in data source

You might have faced a refresh error when a column name gets changed in data source, it happens when column name gets changed in data… Read More »Refresh error from changing column names in data source

 9,005 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

 9,618 total views,  7 views today