Level: Beginners I blogged on conditional formatting in Power BI Table visual here when it was released in the May 2016 Power BI Desktop update. At the time of first release, the conditional formatting was pretty basic with only 1 formatting option available. Over time, Microsoft has improved this feature, and now, it is […]
Regular readers of my blog probably get sick of hearing me rave about the latest new thing in Power BI. This month there is an absolute cracker – Q&A in Power BI Desktop. In case you don’t know, Q&A is a natural language query tool that allows you to ask […]
Level: Intermediate I have been aware of the TREATAS function for a very long time. I have tried to understand how it works a few times but could never really work it out. I think part of the problem is the function name TREATAS is not very descriptive. To contrast […]
I’m really pleased and excited to introduce you to Daniil Maslyuk (Twitter: @DMaslyuk). I first met Daniil about a year ago (originally via email) as he was preparing to move to Australia. Daniil made the plunge shortly there after and migrated to Australia (from Russia) – he now works as a Power BI consultant […]
Level: Intermediate Background I was reading the questions at http://community.powerbi.com today and saw an interesting question. In short the OP wanted to know if there was a way to identify (via a measure) if the row in a table had a colour =”Blue”, but also to check that there were […]
I first learnt about the new DAX UNICHAR function in Power BI by reading Chris Webb’s blog (which was also the inspiration for this article today). One of the uses of the UNICHAR function is to be able to include non text characters inside visuals. When you combine a logical set of […]
Level: Beginners As I often say, sometimes it is the little things that can make a big different for some people – in this case Accountants. I was teaching a Power BI class a few weeks ago and I was discussing how the number formatting options work in Power BI. […]
Level: Beginners/Intermediate In the August 2017 update of Power BI Desktop Microsoft released the new What If feature (first demonstrated at MDIS in July). This new What If capability uses two new DAX functions to complete a task that you have always been able to do manually. You still can […]
The 24th of July, 2017 is the second birthday for Power BI. I thought I would take the occasion of its second birthday to reflect on all the great work that the crack Power BI team at Microsoft has done over the last year. I think it would be […]
Today I sat through the Keynote session at the Microsoft Data Insights Summit. As expected, James Phillips confirmed that MS has been holding back a few killer features to announce at the Summit. Here is the list of new things that are coming that I wanted to share with you […]
I was reading a blog by David Eldersveld last week where he was talking about his entry in the Microsoft Data Insights Summit Data Analytics Challenge. I originally was too busy to enter however I was inspired by his article and thought I should prepare an entry albeit with only […]
At the start of May 2017, Microsoft announced that Export to Excel/CSV would no longer be available to Power B Free users, and would not be part of the new Power BI Premium offering either. Today Microsoft announced that it has listened to community feedback and has agreed to include this […]
I am an enthusiastic sponsor of Microsoft BI. I have been fortunate enough to build a new career off the back of the great products Microsoft has developed, specifically Power BI, Power Pivot and Power Query. Having said that, I am definitely disappointed with the new licensing agreement changes have […]
Microsoft today announced that it is changing the way it licences its Power BI service product. I want to provide my personal view on why it is doing this, what is good and also what is bad about this change. The Problem MS is Trying to Address Let me start […]
Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI users of when to use Excel vs Power BI to author new data models. I […]
Level: Intermediate I have written quite a few articles that contain embedded references to DAX Queries and DAX Table functions in the past. Today I am writing an article that introduces the DAX query language from the beginning so you can learn how to use it and how it will […]
Level: Beginners One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that they need to learn to think about data in tables rather than thinking about data in cells. In the spreadsheet world every cell can be a […]
I love to celebrate successes with the Microsoft Power BI team, but I am also not shy in shouting out when I am disappointed. Back on 25th Nov 2016 I blogged about the then new “Save PBIX from Power BI Service”. At the time I was disappointed in the way […]
Microsoft has recently released a technical preview of Power BI that can be installed on premise inside a company firewall and the Power BI reports can be securely published over the Intranet (not Internet) via SSRS. Today I am sharing my experiences setting up the technical preview for the first […]
Level: Beginners Edit: Sep 2019 There are many best practices for Power BI. I know these things so intuitively now that it is very easy to forget how I incrementally learnt these things along the journey. Most of these things are not “right” vs “wrong” – they are more often […]
Excelerator BI | © 2023 | Sitemap