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
132 total views
Home »
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.
HTML Color picker
HTML Color picker, you can search colors either by color name or color hexacode 175 total views, 1 views today
175 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
147 total views, 1 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
282 total views, 1 views today
Custom column in Power BI
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
389 total views, 6 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
384 total views, 1 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
581 total views, 5 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
1,628 total views, 7 views today
Formatting DAX
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
489 total views, 1 views today
LOOKUPVALUE function DAX
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
2,090 total views
Data Alerts in Power BI service
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
1,296 total views
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
1,316 total views
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
953 total views
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
1,566 total views
Add a columns from examples in Power BI
Power Query add column from examples feature, allows you to add new columns to data model simply by providing one or more example values for… Read More »Add a columns from examples in Power BI
674 total views
Append Queries in Power BI
The append operation in Power Query creates a single table by adding the contents of one or more tables to another, and aggregates the column… Read More »Append Queries in Power BI
1,866 total views, 4 views today
Unpivot Columns in Power BI
Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you… Read More »Unpivot Columns in Power BI
1,175 total views
Fill values in column in Power BI
Power Query provides a FILL operation which allows you to fill up and fill down to replace null values with the last non-empty value in… Read More »Fill values in column in Power BI
1,729 total views, 1 views today
Create a Data Profiling report
The data profile allows a intuitive ways to clean, transform, and understand data which helps you identifying the nuances of the data such as determining… Read More »Create a Data Profiling report
1,159 total views, 6 views today
Profile Data in Power BI
The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI
1,252 total views