The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this point, […]
This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual. As good as Power BI is, it will take Microsoft many more years to make it fully featured. Microsoft Excel is 37 years old, and I can assure […]
Back in 2016, I created this idea at ideas.powerbi.com. I wanted to be able to have 2 different number formats in the same column in Power BI. This is particularly useful for things like a P&L report, but it is also useful for other types of reports. Doing this in […]
I mentioned in an earlier blog that I have been doing some work with the owner of the InfoRiver Power BI Custom visual. I have been testing, given UI feedback, and more recently I have produced some instructional videos. I wanted to share the first of these videos with you […]
This is the third article where I have covered building a P&L in Power BI. My first 2 articles here and here focused on how to use the DAX language to solve some of the common problems with P&L reporting, such as adding sub totals into the visual, % of […]
Excelerator BI | © 2023 | Sitemap