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…

 139 total views,  8 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…

 533 total views,  4 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…

 242 total views,  2 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…

 466 total views,  2 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…

 684 total views,  3 views today

Read More...

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 the cloud and several Microsoft cloud services. There are two…

 564 total views,  4 views today

Read More...

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, and instead of querying and loading values for new column…

 472 total views,  2 views today

Read More...

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 you expect to see months name to be sorted chronologically….

 1,128 total views,  2 views today

Read More...

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 users who can access, edit, and read the content in…

 924 total views,  2 views today

Read More...

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 author or creator of workspace. First login to Power BI…

 382 total views,  6 views today

Read More...

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 to cartesian charts (chart which includes horizontal and vertical axes)…

 2,069 total views,  6 views today

Read More...

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 create a relationship, Power BI suggest a many to many…

 318 total views,  3 views today

Read More...

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 requires two input parameters that is start date, and end…

 728 total views

Read More...

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 say for below given Sales data table, you want to…

 234 total views

Read More...

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 transforms and data source functions and inputs in custom functions….

 914 total views,  13 views today

Read More...

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. Parameters basically is used for changing the argument values for…

 732 total views,  2 views today

Read More...

Show Hide Measures in Line chart visuals using slicer in Power BI


Show and Hide Measures in Line chart visuals based using slicer If you are working on Line and clustered column chart, or line and stacked column chart and using measure to display values in chart…

 1,171 total views,  11 views today

Read More...

Show or Hide Power BI Visuals


Show hide visuals in power bi

 1,900 total views,  11 views today

Read More...

Dynamic Titles in Power BI


Dyamic Titles in Power Bi

 356 total views,  1 views today

Read More...

Report ToolTip page in Power BI


Power Bi allows us to create a report tooltip pages, means you can access a report page inside tooltip.

So for any selected records on visuals you can display more information by displaying a report page as a tooltip.

 268 total views

Read More...