Easily Change Filters & Edit Visual Interactions in Power BI

I want to show you how you can use filter fields and visual interactions in Power BI to great effect. They create simple and very effective ways to make your visualisations easier and more intuitive for the consumer. Filter fields enable you to adjust the results you are showcasing, but instead of having to manually

Continue reading

Advanced Power BI Technique – Multi Threaded Dynamic Visuals

In this post I want to show you what is without doubt one of the most compelling visualisation techniques in Power BI. Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even more

Continue reading

Use DAX To Calculate Difference Between This Year & Last Year

If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions. Some are easy, but others are much more advanced and can be difficult to use. In this post though, I want to take you back

Continue reading
No comments

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

One thing that can seem like a limitation of Power BI is its calendar date table – often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in

Continue reading
No comments