Display Last N months data in Power BI
In this article we will demonstrate how to display last n months data in chart based on selected month in slicer. Means, user will select… Read More »Display Last N months data in Power BI
TOP N and Others in Power BI
In this article we will see how to display the TOP N and Others in Power BI, means to show the top n products and… Read More »TOP N and Others in Power BI
Field Parameter in Power BI
Power BI released a new preview feature called Field Parameters in May 2022 update. Using Field Parameters you can dynamically change the measure or dimension… Read More »Field Parameter in Power BI
Creating Dynamic Title based on Slicer Selection
You can create a dynamic title based on values selected in slicers or can show slicer selected values in text box. Lets create a dynamic… Read More »Creating Dynamic Title based on Slicer Selection
Add Saprkline to matrix in Power BI
Microsoft Power BI team has released a December 2021 update. In this update they have added new features and one of the most excited feature… Read More »Add Saprkline to matrix in Power BI
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
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
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… Read More »Row-Level Security (RLS) in Power BI
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… Read More »Monitor usage and performance in workspace
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… Read More »Power BI Report Performance Analyzer
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… Read More »Import JSON data files in Power BI
Install and Configure on-premises data gateway (personal mode)
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 (personal mode)
Calculated Columns
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,… Read More »Calculated Columns
Sort By Months Name in Power BI
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… Read More »Sort By Months Name in Power BI
Introduction to Workspace in Power BI, Assign Roles and Permission
In Power BI service a workspaces are places to collaborate with colleagues to create collections of dashboards, reports, datasets, and paginated reports. You can add… Read More »Introduction to Workspace in Power BI, Assign Roles and Permission
Rename a Dataset in Power BI Service
Power BI allows you to rename a datasets in Power BI service. You can rename the dataset in workspace, if you are either a report… Read More »Rename a Dataset in Power BI Service
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
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
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
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