Tag: Business Intelligence

Show Top Or Bottom Results Using Ranking In Power BI

In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI. Sometimes you don’t want to show all the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the bottom seven. To

Continue reading

How To Use SWITCH True Logic In Power BI

When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights within Power BI. There

Continue reading

How To Create A Dynamic Power BI Report

In this tutorial, I show you how you can create a totally dynamic Power BI report, using the measuring branching technique and the power of DAX. When I say dynamic, I mean that you may want to highlight one particular insight across all your visualizations on your report page, but then you might want to

Continue reading

Analyze Profit Margin Changes Overtime – Analytics with Power BI and DAX

In this blog post, I will show a really unique and specific example where I’m going to hone in on how you can combine lots of the techniques that I’ve described in many previous tutorials to come up with profit margin changes. These are techniques like Measure Branching, Trend Analysis, and DAX Formula Combinations. What

Continue reading

Power BI Visualization Technique: Learn How To Create Background Design Plates

Here’s a Power BI visualization technique that you can utilize within your reports by using large images in the background. In a lot of demos I have created and showcased during the Enterprise DNA webinar series or learning summits, I always put a lot of effort in the visualization. I always put shapes in my

Continue reading