For several years now, Power BI and Excel have been developing side by side with the idea that analysts do not save all their tables exclusively on a local computer, OneDrive or SharePoint repositories, but that they can also download them from Power BI reports that are published on the company’s tenant. If you use a Microsoft365 subscription that is connected to a company account, you can easily retrieve such tables.
How to replace zeros with empty cells? Although this question seems simple, you may find yourself in a situation where you need something like this, and you will not have the right answer. When it comes to data in Pivot tables, it is logical to define this in the options. But they allow you to determine how to treat empty values, not zeros. Zero is not an empty value. You will find out how to replace zeros, regardless of the type of table, in the “recipe” that follows…
In the previous texts, you could learn about several ways to consolidate data, and here we will deal with consolidation using a pivot table. To be able to achieve this we will use the Pivot Table and Chart Wizard. This is a hidden option that you can’t find in any of the ribbons (you can add it yourself, if you wish, by adjusting the layout of the ribbon), and it makes it easier to create pivot tables and charts …
Pivot tables are reports that, above all, are used to interpret data based on given criteria. Sometimes a pivot table can also be used as a data source to make one or more new pivot tables. This usually happens when you want to create a pivot table from an existing business report, based on a query to the transaction database, and thus use the data that are available in initial pivot table.
Calculated Items allow you to create formulas based on arithmetic operations between elements in rows and/or columns within a pivot table. Sometimes Excel can get confused and display incorrect results due to a misinterpretation of the order of computational operations. Solve order is an option with which we can change the order to get the correct result.