by Chris Webb | Apr 20, 2018 | Chris Webb
A very common requirement when building Power BI reports is to allow the end user to change what is displayed on a chart axis dynamically. A lot of people have blogged about how to do this – Kasper’s blog post here is a great example – but the problem is that all of...
by Chris Webb | Apr 15, 2018 | Chris Webb
In the comments to my last blog post on how the order that you select columns can affect the output of certain calculations, both Bradley Sawler and John B. Thomas pointed out something very useful that I didn’t know about: that the order you select columns can also...
by Chris Webb | Apr 12, 2018 | Chris Webb
Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the...
by Chris Webb | Apr 8, 2018 | Chris Webb
The April 2018 release of Power BI Desktop included a new M function: Binary.InferContentType. There’s no online documentation for it yet but the built-in documentation is quite helpful: I tested it out by pointing it at the following simple CSV file: This post first...
by Chris Webb | Apr 4, 2018 | Chris Webb
I think Power BI’s a great tool, but like most Power BI users I have a list of my own pet features that I would like to see implemented to make Power BI even greater. What I would most like to see addressed is the fact that, right now, Analyze In Excel only works with...
by Chris Webb | Mar 28, 2018 | Chris Webb
It’s that time again: the BI Survey (the world’s largest survey of BI tools and users) needs your input. Here’s the link to take part: https://www.efs-survey.com/uc/BARC_GmbH/396b/?a=101 This post first appeared...
