In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits I’m going to start by creating a new measure and renaming it as Total Costs.
Tag: Supporting Table
One of the most common concerns I see in the Enterprise DNA Support Forum relates to creating dynamic visuals. In this blog, I’ll focus my discussion on multi-measure Power BI dynamic visuals. I have a tutorial about this topic, which I’d like to highlight in this article. The tutorial will show you how to work and present your results in a dynamic way and how you can change
We’re going to explore a really unique Power BI grouping or segmentation example in this tutorial. We’ll create an aged trial balance grouping inside Power BI. This technique involves re-using many of the grouping and segmentation patterns that we already learned. Utilizing Power BI grouping patterns for this unique example is no different. The idea
Here I want to showcase a unique idea around financial reporting, which is allocating results to predetermine table templates inside Power BI. After spending quite some time working out how to create these custom templates, I’ve finally devised a strategy around Power BI development. This strategy enables us to not only create these templates, but
In this tutorial, I run through an advanced analytics technique in Power BI called Threshold Triggers. With this analytical concept in Power BI, you can set certain thresholds or certain trigger points via a supporting table in your data model. Once you’ve added this supporting table and it’s inputs, you can then run logic through