In this video, Patrick shows how you can use bookmarks and selections to create interesting reports to show different aspects of your data. He also shows a very cool way to change between those select…

Workaround for some missing basic Power BI functionality: Right aligning text and dealing with mixed number formats within one column.

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 abl…

In this blog post I am going to demonstrate how to achieve Pagination in Power BI reports, using the new Bookmarking feature. I got this question from a follower on Twitter Murali Brishna With the …

Selecting Appropriate Data Visualization with PowerBI . PowerBI help in dealing with visualizing volumes of datasets in the most convenient manner.

Charles Darwin circumnavigated the globe with Captain Robert Fitzroy between 1831 to 1836. He is most famous for he theories on evolution, which were very much informed by this journey. This Power BI report is an attempt to tell the story of this voyage and some of his discoveries along the way. ...

As a graphic designer who designs dashboards, I give you all the tips, tricks, and guidelines for creating a dashboard that everyone will love.

Data science students often focus on machine learning algorithms, overlooking some of the more routine but important skills of the profession. I’ve lost count of the number of times I have advised…

Case Do you also regularly get the question from customers about which data the chart shows and what...

This is best shown with an image of my completed Power BI Desktop file. The data below is from Gap Minder in which it shows how many hours people work by country over time. What I wanted to do was to compare based on Australia which countries work more and which countries work less. As you can se...

This measure allows you to predict dependent values Y from independent values X. NAME: Simple linear regression DESCRIPTION: Estimate Y values based on X values. PARAMETERS: Name: Category Tooltip: The category for which you have known X and Y values Type: Categorical field Name: Measure X T...

Timeline Storyteller, a new custom visual for Power BI I created with a team of other researchers at Microsoft, is now available in the Office Store for anyone to use. Power BI is a powerful data storytelling tool, and with Timeline Storyteller, data journalists can now visualize a sequence of events in a compelling way using the large palette of design options that Timeline Storyteller provides. Learn more about this latest custom visual from the Microsoft Research team.

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is an animated bubble chart that allows you to compare two entities against each other. Modu…

Collection of data visualizations to get inspired and finding the right type.

In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software.  The Dot Plot is used to show distribution using dots among multiple categories or attributes. Module 64 – Dot P…

Local government is always looking for ways to target its resources more effectively. Lancashire County Council's business intelligence team recently began exploring Power BI as a powerful platform to visualise Lancashire's latest data for health and its wider determinants at neighbourhood level.   ...

Histograms require some statistical knowledge to grasp, and without the tidbits, the distribution chart looks like any other bar chart. So much more though. They can show a lot about your data, and…

NAME: Arrow Rating   DESCRIPTION: This quick measure shows an up arrow or down arrow when comparing a target value against a target value, or else "--" if not. Can also be inverted if a lower value is better compared to the target.   PARAMETERS: Name: Base Value Tooltip: Your base value / measure. T...

Learn everything you should know about data dashboards: why you need them, their benefits and dashboard examples & templates to illustrate.

Who doesn't love KPI icons in tables?  They provide instant feedback on performance metrics, alerting us to a job well done or for the need of further action.  Either way, they help us to better manage our portfolio.   One of the most powerful aspects of MS Power BI Desktop, the DAX formula language...

In this module you will learn how to use the Quadrant Chart Custom Visual.  The Quadrant Chart is used to show a distribution of data across separate quadrants. Module 63 – Quadrant Chart Downloads…

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out…

I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was up or down. As well as if there was no data to say that there was no data. So this is how I achieved thi...

A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon…

In this module you will learn how to use the Power KPI Custom Visual.  The Power KPI displays your KPI indicator values on a helpful multi-line chart with labels. Module 61 – Power KPI Downloads Po…

Early adoption of new custom visuals in Power BI is a great way to explore new insights, or to impress your colleagues, boss or clients, and captivate your report consumers. So, when you want to explore the latest custom visuals that were released in Office Store, or from Power BI Desktop (As seen in the …