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.
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…
52 total views, 52 views today
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…
100 total views, 77 views today
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 the cloud and several Microsoft cloud services. There are two…
52 total views, 14 views today
Choose columns and Remove columns are operations that allows you to define what columns you need to keep in your table and which ones it needs to remove. Lets take a look at how to use…
137 total views, 1 views today
A funnel chart allows you to visualize a linear process that has sequential connected stages. It is named as funnel because in most of cases, a funnel chart is shaped like a funnel with the…
218 total views, 1 views today
REMOVEFILTER function is a Power BI filter function in DAX, It removes filters from the specified tables or columns. It can only be used to remove filters but not to return a table. SYNTAX REMOVEFILTERS([<table>…
159 total views, 1 views today
Power Query allows you to split a column with various options, one of them is split columns by positions which split a text columns at specific positions within a given text value. Lets see how…
179 total views, 1 views today
TOTALYTD is a Power BI time intelligence function in DAX, which evaluates the year-to-date value of the expression in the current context. DAX SYNTAX TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) expression An expression that returns a scalar value. dates Is a…
199 total views, 1 views today
REPLACE function is a Power BI text function in DAX, which replaces part of a text string based on the number of characters you specify, with a different text string. SYNTAX REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)…
214 total views
Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model, and instead of querying and loading values for new column…
282 total views, 4 views today
Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs an aggregation that you specify such as sum, max, min,…
298 total views, 2 views today
PATHREVERSE function is a Power BI Parent and Child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from…
76 total views, 1 views today
PATHITEM function is a Power BI parent and child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left…
57 total views
PATHLENGTH function is a Power BI parent and child function in DAX, which returns the number of parents to the specified item in a given PATH result, including the specified item. SYNTAX PATHLENGTH(<path>) Path Is…
119 total views, 2 views today
Path function is a Power BI Parent and Child Functions in DAX, which returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing…
316 total views
When you perform sorting on months name, you will see that months name are sorted alphabetically as text, strings are sorted alphabetically by default. While you expect to see months name to be sorted chronologically….
339 total views, 9 views today
EOMONTH function is a Power BI Date and time function in DAX which returns the date in datetime format of the last day of the month, before or after a specified number of months. It…
178 total views
A Heat map is used to visualize the density of data using colors where highest data value is displayed through dark heated color, and same color turns in light color for lowest values. In Power…
210 total views, 2 views today
REPT functions is a Power BI text function in DAX which repeats text a given number of times. SYNTAX REPT(<text>, <num_times>) text is the text that you want to repeat. num_times is a number which…
49 total views, 1 views today
Power BI August 2020 update has released a new feature Import text using examples, which allows you to import text/csv file which allows you to specify sample output values for the data you would like…
218 total views