Hi I'm Alan, a new name here at Burningsuit and this is the first of what I hope will be many Blog posts from me. Recently I was talking with a client who wanted Narrative Text on their Report, so I started looking at the options. Of course there's always the trusty Text Box option straight from Power BI's Insert menu – there are plenty of formatting options in there and that may well suit your needs. But what if… Read More
THE BURNINGSUIT BLOG
Charticulator in Power BI #6
2D Region Plot Segments Part 2 – Sorting, Spacing, Aligning etc. In my last blog post, we delved into the mind-bending world of plot segment sub-layouts. Also at long last, we learned how to build a simple bar chart in Charticulator. However, are you still asking yourself; so what? What is the benefit of using Charticulator over using the default visuals installed with Power BI? After all, most of the charts we've created so far; column, bar and line charts… Read More
Charticulator in Power BI #5
2D Region Plot Segments Part 1 - Sub-Layouts. In my last post I showed you how to create a line chart using a symbol as your glyph. You also learned something more important; that if you bind a numeric field to the Y-Axis you will create a "numeric" axis, a value axis in the true sense. Glyphs will then be plotted against this axis according to their value despite the shape of the glyph. However, you may be a little… Read More
Charticulator in Power BI #4.
Using Symbols & Y-Axis Weirdness. If you've been following along with my earlier posts on Charticulator, it may not have escaped your notice that I've always used either a Mark or a Line in the Glyph pane. Also, I've only ever created Column type charts in my examples. In this post, however, things are about to change because we're going to turn our attention to creating "Point" style charts, such as Line Charts and Scatter Plots, which use a Symbol… Read More
Charticulator In Power BI #3.
Binding Data. In my last post, we took a tour around the Charticulator screen and learned about the Attributes pane which lists the attributes of the currently selected Layer. For example, to show the attributes of the rectangle mark of the glyph, select "Shape1" in the Layers pane and the Attributes pane will show the attributes for "Shape1". In Charticulator, you can associate a field with an attribute by "binding data" to it and this will drive the behaviour and/or… Read More
Charticulator In Power BI #2.
Taking a Tour Around the Screen Since my last blog post, I've been looking more closely at some of the resources "out there" if you want to learn about Charticulator, particularly the YouTube videos. I hope at this point you're not interested in seeing people showcase their amazing talents at using Charticulator; "Hey presto!" and it's done! "Here's an amazing chart I've created in Charticulator and here's the complex DAX I've used to do it! Oh, and I'll just use… Read More
Charticulator in Power BI #1.
Creating a Simple Charticulator Chart Recently a new custom visual has come into the Power BI world. Charticulator (http://charticulator.com) is a visualisation that lets you build other visualisations. It's not easy, but the results are beautiful and if you need a particular data visualization you can't get anywhere else, it's fantastic. Note: At the time of writing, Charticulator is still in preview. This means that some aspects of the interface may change and you may find that screenshots shown in… Read More
Why You Should Never Assume Your DAX Code is Correct; Taking a Closer Look at Bi-Directional Filtering
I recently listened to a thought-provoking blog from Alberto Ferrari (https://ssbi-blog.de/podcast/experts-talk/chat-with-alberto-ferrari/). In it he says, "What scares me is the amount of people that are building reports that are wrong, that are producing wrong numbers but don't know that. They just trust the numbers they see because they have no way of controlling them or debugging them. Maybe they don't have the knowledge to correct them." So in other words, we must never just believe the numbers that DAX gives… Read More
Taking a look at the Power BI Building Blocks
I've just posted a new video over on our YouTube Channel. In our Training we often get questions about the structure of Power BI, how do Dataflows and Datasets fit together, when do I need a Gateway, and how does automatic refresh work with these structures? The answer is that it's complicated. Power BI is growing and now there are many ways to connect, store and report on data. So I thought the best way to explain this was with… Read More
Where do I make data transformations in Power BI ? Roche’s Maxim
When we're Training on Power BI a frequent question we get is "I need to make changes to my data for reporting, where is the best place to do that, in the Data Model with DAX, or in Power Query?" The answer is, as ever "It depends". To answer the question properly, we need to understand where we can make data changes in Power BI, then I can introduce a maxim that explains the best place to make those changes.… Read More