Power BI Tutorials : 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.
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
219 total views, 1 views today
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
262 total views, 1 views today
In this article we will see how to display the TOP N and Others in Power BI, means to show the top n products and… Read More »TOP N and Others in Power BI
1,644 total views, 2 views today
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
994 total views
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
480 total views
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,154 total views, 2 views today
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,052 total views, 2 views today
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,250 total views, 2 views today
When data is loaded into Power BI model, most of the time Power BI automatically detect the data type of columns. Some times Power BI… Read More »Change column data type in Power BI
1,832 total views, 2 views today
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,434 total views
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
2,719 total views
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
2,937 total views, 1 views today
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
2,262 total views
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
4,701 total views
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
7,996 total views, 2 views today
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
8,958 total views, 4 views today
Formatting a DAX is good practice as it makes your DAX code well defined and readable. If you have written a DAX code which is… Read More »Formatting DAX
1,713 total views
LOOKUPVALUE function is a Power BI Filter function in DAX, it returns the value for the row that meets all criteria specified by one or… Read More »LOOKUPVALUE function DAX
6,234 total views, 1 views today
Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can only… Read More »Data Alerts in Power BI service
3,321 total views
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
3,273 total views