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.
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…
For a certain period of time, when I need to split data in a column, my first choice is to use the Power Query add-in and the Split Columns option. However, there are still users who do not know how to use it, so I remembered that for this purpose we can also use the Excel option Text to Columns. In this “recipe” you will find out a practical way how to split one column into several.
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…
