Skip to main content

Power BI Best Practices - Part Three

Overview
In this article, we will talk about the best practices to be considered while we are working with Power BI Report development. I have divided the best practices into the following three parts. This is the last article in this series. Please visit my other articles of this series using the following URL,
During the entire series of the best practices, we have covered the following concepts.
  • Best Practices for Power BI (. PBIX) file preparation (Part – 1)
  • Best Practices for Power BI (. PBIX) Properties (Part – 1)
  • Best Practices to use Query Editors (Part – 1)
  • Best Practices for Tables and Relationship (Part – 2)
  • Best Practices for creating Calculated Columns, measures, and Fields (Part – 2)
  • Best Practices for Data Analytical Expressions (Part – 2)
  • How to make Documentation within PBIX file (Part – 3)
  • Best Practices for Power BI Report Design (Part – 3)
In this article, we will talk about the following concepts for the best practices.
  • How to make Documentation within PBIX file
  • Best Practices for Power BI Report Design
Let’s get started!
How to make Documentation within PBIX file
  • Document the Solution File
    • This is a very good practice, we suggest to our clients.
    • We recommend having a first or last page in a report which has following information about the report.
      • Owner Name
      • Data Source Information
      • Consumed Table List
      • Important Definitions/Terms used in the data source
      • Useful Measures Information
    • Make sure before you publish the report on Production, that you hide the page.
    • This is only for a development perspective.
  • Descriptions for Fields
    • Add a proper description of Fields, Calculated Columns and Measures.
  • Comments in DAX Calculations and M Query
    • We also recommend using comments in every DAX expression.
    • This would be helpful for others to understand the logic or calculation.
    • We have not observed if any M query is used in the report or not.
  • Rename the Query Steps
    • Steps which are added in the query editor are auto-named.
    • We recommend renaming it for a better understanding of the other users.
Best Practices for Power BI Report Design
We follow the following best practices while designing for any corporate audience.
  • Company Logo
    • Use the Logo in their background.
  • Data Timestamp to show, when it was refreshed last
    • We can implement it, to show the end user, when the data was refreshed last.
  • Less use of scrollable Page
    • End users always feel difficulty when the report has a scrollable page.
    • We do not recommend making the page scrollable if not necessary.
    • Instead of making page scrollable, use Bookmark and Selection Pane.
    • Census dashboard doesn’t have a scrollable page which is good.
  • Use Basic Reporting Filter
    • Power BI provides the following type of filters.
      • Visual Level
      • Page Level
      • Report Level
    • Use the filters wisely as peryour  requirement.
  • Limit the number of visuals in the report
    • If we place so many visuals on the single page, it will slow down the performance.
    • We recommend using a maximum of eight visuals per page.
    • Sometimes, based on requirement we need to add more visual on the page, at that time we need to prioritize and choose visualization wisely.
  • Remove unnecessary interaction to improve the Performance
    • By default, interaction is added to every visualization.
    • We recommend turning off the interaction if it is not needed which will improve the report performance.
  • Use Certified Custom visuals
    • If the organization is planning to use any custom visuals in future, make sure it is certified.
    • Certified custom visual is the custom visual which facilities the functionality to be exported to PowerPoint and email subscription.
    • To know more about the certified custom visualization, please refer to the following here.
  • Do not use Hierarchical Slicers
    • We recommend, not to use any hierarchical slicers in the report.
    • Currently, we have observed that no hierarchical slicers are used in the report.
  • Also, before planning any report development, we will consider the following points
    • First, we think about the data in Grid
    • We use proper suitable charts which represent the data in an effective manner.
    • Use the proper color scheme.
    • Do not mess up, make it simple.
    • Use simple titles and headers.
Conclusion
This is how we recommend the best practice to prepare the Power BI report. Hope you love this article. Stay connected with me for more amazing articles!

Comments

Popular posts from this blog

How to partition or split DataTable in C#?

Today we will discuss how we can divide or split a very large data table into fixed size of chunks? Scenario: Suppose there is a data table which has 1000 Rows. When you perform for each loop on data table and read each row at that time it will take too much time. If we devide 1000 Rows datatable into 10 fixed sizes (e.g. 100 Rows) datatable, It will take less time. Let's check how to achieve it. Here is a code. private static List<DataTable> SplitTable(DataTable originalTable, int batchSize) { List<DataTable> tables = new List<DataTable>(); int i = 0; int j = 1; DataTable newDt = originalTable.Clone(); newDt.TableName = "Table_" + j; newDt.Clear(); foreach (DataRow row in originalTable.Rows) { DataRow newRow = newDt.NewRow(); newRow.ItemArray = row.ItemArray; newDt.Rows.Add(newRow); i++; if (i == batchSize) ...

How To Lock Objects In Power BI

Overview Sometimes, there is a situation where when we open a report and click on any visual it accidentally nudges a chart a little bit to the right or left. Sometimes, by mistake when viewing a report, the arrangement of visuals scatters a little bit. Microsoft rolls out one new amazing feature to resolve this issue, that is, Lock Objects in Power BI. Advantages of using this feature When our purpose is to only view a report, this feature is a boon for us. Visualization’s position is not changed. Saves a lot of the developer's time to resolve the position related issues. Note   -  This feature is not saved with the report. So, every time you open a report, you need to enable this feature. Now, let’s understand this feature in a brief manner. To understand this, I will first show you one report in which I have not enabled “Lock Objects” feature. Step 1 The below screenshot shows my report which doesn’t have the enabled Lock Objects feature. ...

Use SharePoint Online List As A Data Source In Power BI

Introduction In this article, we will check how we can use SharePoint List as a data source in Microsoft Power BI. Please follow the below steps to establish the connection of SharePoint Online list with Power BI.  Step 1 Open Power BI Desktop > Get Data > Click More.   Step 2 Search for SharePoint > SharePoint Online List.   Step 3 Enter the URL of your SharePoint site.   Step 4 Click on Organizational account > Sign In.   Step 5 It will open the screen of Office 365 Login > Enter Credentials.   Step 6 Click on Connect.   Step 7 It will show all the lists available in the SharePoint - lists are on the left corner and their preview is on the right. Select all the lists which you want to use directly in the Power BI. Click on Load.   Step 8 It will load all the lists. Expand "Fields" column to view all the fields shown in the SharePoint List.   We can also view all the...