It’s Complicated – Dealing with Many-to-Many Relationships in Power BI31st July 2019If you’re building a DataModel in Power BI, and creating relationships between tables you may have come upon this message. What the heck does “ Cardinality Many-Many” mean? And what is the “ Significantly different behaviour” they’re warning me about...
The Filter Pane Pain in Power BI29th July 2019The July 2019 update to Power BI is now out, you can get all the details from Microsoft here. As usual there are a list of new features and tools...
Understanding the “Analytics” Lines in Power BI22nd June 2019In our Power BI training courses, I show people how to add a Constant Line to a clustered column chart by using the Analytics section of the...
Joke’s Over – send Email to users when refresh fails12th June 2019I do a lot of Power BI Training, and have been doing it since Power BI came out over three years ago. So to keep myself fresh, amuse myself and...
Best and Worst: Two approaches to finding Top or Bottom N Percent using DAX19th May 2019Ever wanted to find which are your best or worst customers or best or worst products by a metric such as Total Sales? Finding a simple TopN or BottomN...
7 Secrets of the Matrix Visual 20199th April 2019Some of you Excel users may have realised that the Power BI Matrix visual is just an Excel Pivot Table by another term. You even get buckets for “Rows...
New Power BI feature, embed reports securely in Web Pages4th February 2019We know that we’ve been able to publish Power BI reports to the web for some time. It’s a good feature, allowing us to publish our “Strictly Come...
Blog
As Microsoft software evolves and new opportunities to enhance your data visualisation and integration evolve through Power BI, we like to keep you up to date. Our blog not only looks at new developments but shares consultancy news and training opportunities. Sign up to our blog to stay in touch.
