How I designed a layered donut chart

This is a long overdue post, probably one of the most received questions on my blog was, How I designed a visual in one of my Power BI reports I published under my portfolio. As I promised to many, let’s see how I did it. Sorry to spoil, but it is nothing but a layered Donut Chart, but how I approached to show values probably is a good one. Be aware; I created this report quite a long time ago, If I do it now, I probably would have taken a different approach or different visuals.

Source : Prathy’s blog
Read more…

Six Sigma Control Charts in Power BI

I have had a couple of requests for help during my live training classes and online training classes on how to build a Six Sigma Control Chart. Now I am not professing to be a Six Sigma black belt, but I do know how to write DAX and I do know how to use Power BI. So here goes. This is what I am going to build.

Source : Excelerator BI
Read more…

Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons

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 these solutions involve a lot of work remodelling your data and writing DAX code. However, the good news is that now we have Bookmarks and Buttons in Power BI there’s a new, easy, code-free way of achieving the same result, at least for some chart types. In this post I’ll show you how using the same data that Kasper used in his post.

Bron : Chris Webb’s BI Blog
Lees meer…

Adding a vertical line or marker to a chart in Power BI

A business user came to me asking “how can I get a vertical line on Line Chart in Power BI like my Excel report?”. I was like, “It’s straightforward. We have this analytics pane which lets you add so many types of lines ? “. But, quite quickly I understood, I cannot draw a vertical line as we do in Excel or SSRS.

Bron : Encore
Lees meer…