Visual zoom slider feature in Power BI
Recently Power BI has released November 2020 update, in this update one of the coolest feature is that now you can add a zoom sliders… Read More »Visual zoom slider feature in Power BI
Home » Power BI Tutorials »
Power BI Tutorials
Power BI Tutorials : 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.
Create Relationship between tables when both tables having duplicate values
Sometime you are required to create a relationship between tables when both tables are having a duplicate values. In this case, If you try to… Read More »Create Relationship between tables when both tables having duplicate values
SAMEPERIODLASTYEAR Function DAX
SAMEPERIODLASTYEAR is a Power BI time intelligence function in DAX which returns a table that contains a column of dates in the current selection of… Read More »SAMEPERIODLASTYEAR Function DAX
Create a calendar table in Power BI
In Power BI there are two DAX functions that you can use to generate a date series that is CALENDAR and CALENDARAUTO. The CALENDAR function… Read More »Create a calendar table in Power BI
TOPN Function DAX
TOPN function is a Power BI table manipulation function in DAX which returns the top n records from table. If you specify the number 0… Read More »TOPN Function DAX
FILTER Function DAX
Filter is a Power BI filter functions in DAX which returns a table that represents a subset of another table or expression. It filter the… Read More »FILTER Function DAX
Merge in Power BI
Merge Queries in Power BI allows you to join two existing tables together based on matching values from one or multiple columns. Basically, it is… Read More »Merge in Power BI
Small Multiple Line Chart Power BI Custom Visual
The Small Multiple Line Chart also known as Trellis bar chart is custom visual that is available in Power BI, it allows you to display… Read More »Small Multiple Line Chart Power BI Custom Visual
USERRELATIONSHIP Function DAX
USERRELATIONSHIP function is a Power BI Relationship function in DAX which Specifies the relationship to be used in a specific calculation as the one that… Read More »USERRELATIONSHIP Function DAX
GENERATESERIES Function DAX
GENERATESERIES function is a Power BI Table Manipulation function in DAX which returns a table with one column which contains sequential values from start to… Read More »GENERATESERIES Function DAX
RELATED Function DAX
RELATED function is a Power BI Relationship function in DAX which returns a related value from another table. The RELATED function requires that a relationship… Read More »RELATED Function DAX
What If Parameter Power BI
What if Parameter gives you the ability to transform data dynamically. Using this you can easily evaluate you data behaviour under different conditions dynamically. Lets… Read More »What If Parameter Power BI
Change the Data Source dynamically in Power BI using Parameters
Changing the Data Source dynamically in Power Bi using Parameters Parameters in Power BI , basically is used for changing the argument values for particular… Read More »Change the Data Source dynamically in Power BI using Parameters
Parameters in Power BI
Introduction to Parameters in Power BI Desktop Parameters in Power BI provides the flexibility to change the output of queries depending on their value dynamically.… Read More »Parameters in Power BI
SELECTEDVALUE Function DAX
SELECTEDVALUE Function is Power BI Filter Functions in DAX which returns the value when there is only one value in the specified column else it… Read More »SELECTEDVALUE Function DAX
CONTAINS Function DAX
CONTAINS function is a Power BI Information function in DAX which returns TRUE if there exists at least one row where all columns have specified… Read More »CONTAINS Function DAX
CALENDARAUTO Function DAX
CALENDARAUTO function is a Power BI Date and Time Function in DAX which returns table with single column which contains a contiguous set of dates.… Read More »CALENDARAUTO Function DAX
FIND Function DAX
FIND Function is a Power BI TEXT function in DAX which returns the starting position of one text string within another text string. FIND function… Read More »FIND Function DAX
ADDCOLUMNS function DAX
ADDCOLUMNS is a POWER BI Table Manipulation Functions in DAX which is used to add a calculated columns in table. Basically, ADDCOUMNS returns a table… Read More »ADDCOLUMNS function DAX
DATATABLE Function DAX
DATATABLE function is a Power BI Table manipulation function in DAX which allows us to create a table. Using Datatable function, You can define column… Read More »DATATABLE Function DAX