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

 565 total views

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

 581 total views,  1 views today

How to fetch alphanumeric string from table

Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table

 617 total views,  3 views today


FORMAT function is a Power BI text function in DAX, which converts a value to text according to the specified format. Syntax FORMAT(<value>, <format_string>) value… Read More »FORMAT Function DAX

 1,462 total views,  5 views today

Small Multiples Preview

Small Multiple or trellising allows you to split a visual into multiple versions of itself, presented side-by-side, with its data partitioned across these versions by… Read More »Small Multiples Preview

 343 total views,  1 views today

Scatter charts in Power BI

A scatter chart shows the relationship between two numerical values and displays points at the intersection of an x and y numerical value, combining these… Read More »Scatter charts in Power BI

 464 total views,  2 views today