Learn to select best Excel Charts for Data Analysis, Presentation and Reporting within 15 minutes. Learn about the various excel charts types.

3 common reasons why data visualization dashboards fail, and 7 best practices to make sure they don’t

The importance of color theory is a well-explored topic in art and design. But what about when it comes to information design?

When you design reports in PowerBI using the online designer and not the Power BI Desktop designer you will notice that you cannot insert a picture via the interface. With the development speed of …

A list of reviews on books about Data Visualization and Information Design that are essential for every (self-taught) visualization designer

It started during a presentation of Cathy Dumas at the latest SQLBits where she compared the different charting capabilities of Excel, Power View, PerformancePoint and Reporting Service. One of tho…

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…

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

I was jogging the other morning and ran by a woman hanging a sign for a garage sale. Her advertiseme...

Explore this interactive visualization about the world of visualization itself - see charts arranged by popularity and trends in this collaboration between Google News Lab and Adioma

This Visual Studio Code extension adds the option to directly start and restart the PowerBI Visual tools (pbiviz)

Affordances are a general design concept that comes from physical product design but can be applied to visual design. I first learned about affordances from the book The Design of Everyday Things. …

FlowingData

Svg samples for table and matrix visuals

I got a great question last month on how to implement a histogram in PowerPivot, similar to this great blog post by Tomislav Piasevoli for Multi Dimensional. I decided to solve the problem in Excel…

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…

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into wit…

Did you know that it’s easy to transform Power BI’s Line Chart into a Slopegraph? No DAX or fancy workarounds are required. Slopegraphs are a great way to judge the rate and magnitude o…

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

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…

We show you how to use a KPI or card as a slicer.

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 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.   ...

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...

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...