PowerBI Archives | Dynamics 365 portal & Software For Accounting Firms

Tag Archives: PowerBI

How to list all dates between two dates in PowerBI and distribute numbers evenly among them.

Posted On August 2, 2021 by Jaison Menezes Posted in Tagged in , ,

Consider a scenario where a start and end date along with the total duration for a particular task has been given to us. We have to distribute the total duration equally among all dates between the start and end date. We can solve this issue by the combination of Power Query and DAX. Lets see … Continue reading How to list all dates between two dates in PowerBI and distribute numbers evenly among them.

Delete multiple tables or columns at once in PowerBI

Posted On May 4, 2021 by Jaison Menezes Posted in Tagged in

While importing data into PowerBI we can choose the tables we want to load in the data model but we cant choose specific columns, although columns can be removed through advanced editor or by manually deleting them one by one this can also be done without using advance editor and multiple columns or tables can … Continue reading Delete multiple tables or columns at once in PowerBI

Use Microsoft Forms with Power BI Reports

Posted On April 3, 2021 by Jaison Menezes Posted in Tagged in ,

Sometimes we would want to ask users about their thoughts , opinions or ask some questions along with a PowerBI report. That is, we would need  to collect information about the user through PowerBI App.  This can be done by creating a Microsoft Form inside PowerBI interface to collect user information. This can be demonstrated … Continue reading Use Microsoft Forms with Power BI Reports

How to solve OLE DB or ODBC errors in PowerBI

Introduction: Sometimes while refreshing our dataset in PowerBI or importing new data from existing sources we may encounter OLE DB or ODBC errors as shown in the image below. This might be due to caching issues. To solve this follow the steps: Go to File tab on the ribbon in PowerBI Desktop , then click … Continue reading How to solve OLE DB or ODBC errors in PowerBI

Load Azure Devops Data into Power BI using Odata

In this blog we will see how to fetch Azure Devops Data and based on it create Visualization as per requirements. Step 1: Go to Azure Devops > Go to User Setting > Personal Access Token  Step 2: Once Clicked on Personal Access Token, click on New Token, following popup will appear.  Enter details Name, … Continue reading Load Azure Devops Data into Power BI using Odata

Copying Data From A Table/Matrix in Power BI : September 2018 Update

Posted On September 25, 2018 by Simran Monteiro Posted in Tagged in

Introduction The September 2018 Update of Power BI has finally brought to users, the functionality to copy data from a table or matrix in a report. This has been a much-requested feature as one often finds themselves needing to copy a value or columns of data from a report with no option to do so. … Continue reading Copying Data From A Table/Matrix in Power BI : September 2018 Update

Power BI September 2018 Update: Drillthrough To Another Report Page

The September update of Power BI features an important functionality: the option to drillthough to another page in that report. For example, if a user wants to see detailed data of a product ‘Product 2’, then they can right-click on Product 2 in the main report, select ‘Drillthrough’ and the relevant sub-report to have it … Continue reading Power BI September 2018 Update: Drillthrough To Another Report Page

Conditional Formatting By Values in Power BI: August Update

Posted On August 10, 2018 by Simran Monteiro Posted in Tagged in

In the August 2018 update of Power BI, we can now apply conditional formatting based on field value. This allows us to use a measure or column that contains a color name, a hex name/code and apply that color to the background of the cells and the font in the cells of that column. For … Continue reading Conditional Formatting By Values in Power BI: August Update

PowerBI April 2018 Update: Combo Chart Line Formatting

Posted On April 10, 2018 by Simran Monteiro Posted in Tagged in , ,

Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, these features were not applicable to lines in combination charts like ‘Line and Stacked Column Chart’ and ‘Line and Clustered Column Chart’. With the April update of PowerBI Desktop, we are now able to customise the format … Continue reading PowerBI April 2018 Update: Combo Chart Line Formatting

Top-N Questions & Answers in Power BI

Posted On January 31, 2018 by Simran Monteiro Posted in Tagged in , ,

Introduction: With the latest update of Power BI, you can now ask top-n type questions and get answers based on your dataset. Questions like ‘What are the top 3 products by sales?’ or ‘Top Manufacturer by country’ are examples. This is also valid for bottom-n type questions like ‘Least selling product in a country’. Steps: … Continue reading Top-N Questions & Answers in Power BI