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.
This article demonstrate how to get the difference between to dates in Power Query. You can use the Power Query Duration function that is Duration.Days… Read More »Difference between two dates in Power Query
121 total views
Date functions helps you to create and manipulate the part of date such as date, datetime, and datetimezone values. There are various inbuilt date functions… Read More »Date Functions in Power Query
132 total views
This article demonstrate how to replace multiple columns value at once in Power Query. Lets say, you need to check if column value is blank… Read More »Replace multiple columns values in Power Query
142 total views
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
160 total views
In this article we will demonstrate how to display last n months data in chart based on selected month in slicer. Means, user will select… Read More »Display Last N months data in Power BI
1,423 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,098 total views
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
828 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
438 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
792 total views
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
1,636 total views, 1 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
1,888 total views, 1 views today
Microsoft Power BI team has introduced an AI Insights in Power BI in November 2019 update, which is collection of pre trained machine learning models… Read More »AI Insights in Power BI
1,004 total views
This article demonstrate how to connect and load data from excel file to Power BI. Lets go step by step, here you can see we… Read More »Load Data from Excel file to Power BI
816 total views
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,662 total views
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,694 total views, 1 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,328 total views
HTML Color picker, you can search colors either by color name or color hexacode ๏ปฟ๏ปฟ 1,692 total views
1,692 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,476 total views, 1 views today
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,780 total views, 2 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,163 total views