We now see a line graph like the one below. Head over the Visualization panel and under the list of icons, find the analytics icon as shown below. Scroll down the panel and find the “Forecast” section. Click on the down arrow to expand it if necessary. Next, click on “+Add” to add forecasting on Read More
Month: December 2021
How To Add A Button Using Bookmarks In Power BI
In this article, you will learn how to create a button and how to use it in Power BI reports. In a Power BI report, you can add different types of buttons, as shown in the below image. In this article, I will create a button using a bookmark. A bookmark is a very useful Read More
How to Add a Column with Fiscal Month or Fiscal Week Number Not Starting From Jan 1?
Part I – Fiscal Month Here is a potential solution assuming you have some kind of data table with a column called Value that has your dates in it: Create a “Standard Month” column using MONTH([Value]) For example, create a “Custom Month” column for the Fiscal month starting from April 1: Part II – Fiscal Read More
How to Optimize Performance in Power Query
Occasionally, organizations will need to address performance issues when running reports. Power BI provides the Performance Analyzer tool to help fix problems and streamline the process. Consider the scenario where you are building reports for the Sales team in your organization. You’ve imported your data, which is in several tables within the Sales team’s SQL Read More
How To Convert UTC to Local DateTime in Power BI
Solutions 1: Convert Time Zones – FORMAT Even if your SharePoint site’s regional settings are correct (or whichever data source you’re pulling from), Power BI could convert it to the wrong time zone upon import. It’s a quick fix, luckily. Instead of using your “modified,” “created” or other date fields in your report, we’ll create Read More
How to Export a Table from Power BI Desktop to Excel
There are some ways to export Power BI Desktop data in Excel. You can copy the entire table, including all DAX calculated columns, very easily and paste it on a destination like Excel. This way is good for a small volume of data. Go to Date View and select the table you want to export, select Copy Table and then paste it in Read More