Microsoft Copilot & quick measures

Microsoft Copilot is a chatbot, based on ChatGPT, and is integrated within many Microsoft services and applications. If you use it in Power BI Desktop reporting platform, it enables you to create quick measures and to generate DAX statements based on natural language. With Microsoft Copilot, creating measures has become much simpler, and you will find out how it is used in the “recipe” that follows.

Power BI tables in Excel

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.

Visual Calculations

If you want to present a report based on data, you will do so by connecting to the source, purifying, modeling it and then adding appropriate visualizations. As part of the modeling process, we often created measures and calculated columns by writing DAX statements. In a similar way, we were able to add Quick Measures. Now there is an even easier way, and that is to create calculations within a visual…

New formatting options

Power BI Desktop, in its December edition, brought several new options for formatting Column and Bar visualizations, which we can use to make them much more functional and beautiful. In addition to this option, this “recipe” will show some new features that have been added to the data labels option. Relax and enjoy, here are some interesting contents…

New Slicer visual

Slicers are interactive objects used to filter pages or the entire Power BI report. They haven’t changed much since their inception, and since they represent an essential component of the report, they got a small facelift. Since November, a new Button Slicer visualization has appeared, which has the properties of traditional slicers, as well as some additional formatting options that make it much more beautiful. Let’s see what it has to offer!