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 unpivot are split in two columns that are Attribute and…

 130 total views,  97 views today

Read More...

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 a column. Lets look at an example of using a…

 172 total views,  30 views today

Read More...

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 anomalies, examining and developing the underlying data structures, and querying…

 46 total views,  1 views today

Read More...

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 data such as determining anomalies, examining and developing the underlying…

 253 total views,  24 views today

Read More...

LASTNONBLANK function DAX


LASTNONBLANK function is a Power BI time intelligence function in DAX which returns the last value in the column filtered by the current context for which the expression has a non blank value. It returns…

 271 total views,  6 views today

Read More...

Row-Level Security (RLS) in Power BI


Row-Level security (RLS) is a feature of Power BI that can be used to restrict data access for given users, so the appropriate person can see the appropriate records. Row-Level security uses a DAX filters…

 327 total views

Read More...

Custom function in Power BI


Custom function in Power BI allows you to use a same piece of code repeatedly multiple times. Sometime, you may get a situation where you need to use the same set of transformations to different…

 343 total views,  2 views today

Read More...

Monitor usage and performance in workspace


This is a performance and usage metrics features that you can use in a workspace. Using these metrics, you can view who is using your reports, how they are using the report, what actions are…

 111 total views,  4 views today

Read More...

Radial Gauge Chart Power BI


A Radial Gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI). The line or needle represents the goal or target value….

 221 total views,  1 views today

Read More...

Power BI Report Performance Analyzer


Performance Analyzer is a tool within Power BI desktop, that allows you assess your report’s performance and identify area of improvement. Using this you can identify the time taken by each visual to query for…

 342 total views,  4 views today

Read More...

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 those strings. Following is the sample table named Numbers which…

 188 total views,  1 views today

Read More...

TRUNC function DAX


TRUNC function is a Power BI math and trig function in DAX, which truncates a number to an integer by removing the decimal, or fractional part of the number. TRUNC function does not round the…

 163 total views,  1 views today

Read More...

Import JSON data files in Power BI


Microsoft Power BI allows us to connect with multiple data sources such as SQL Server, Excel, Text/Csv, XML, Pdf, and JSON and many more, here we will focus on how to import JSON data file…

 449 total views,  2 views today

Read More...

LOWER function DAX


LOWER function is a Power BI text functions which converts a text string to all lowercase letters. SYNTAX LOWER (<text>) text is the text you want converted to lowercase, or a reference to a column…

 66 total views

Read More...

UPPER Function DAX


UPPPER function is a Power BI text functions which converts a text string to all uppercase letters. SYNTAX UPPER (<text>) text is the text you want converted to uppercase, or a reference to a column…

 59 total views,  1 views today

Read More...

MID Function DAX


MID function is a Power BI text functions in DAX, it returns a string of characters from the middle of a text string based on a given starting position and length. SYNTAX MID(<text>, <start_num>, <num_chars>)…

 214 total views

Read More...

FORMAT Function DAX


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 is a value or expression that evaluates to a single…

 313 total views,  7 views today

Read More...

Public, Private and Hybrid clouds


Public, Private, and Hybrid clouds all these are basically a deployment models of cloud computing. Cloud computing is the delivery of computing services over the internet or you can say on cloud. The computing services…

 268 total views,  8 views today

Read More...

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 a chosen dimension. Power BI has introduced a preview version…

 197 total views,  4 views today

Read More...

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 values into single data points. It always has two value…

 242 total views

Read More...