Part II of this series on creative aggs looks at a specific technique I like to call Horizontal Aggs. The theory behind this particular technique is relatively straight forward, although the mechan…
No Training Required Around 18 months ago I was working on a Power BI Report build that was going to have a few hundred monthly users, many of them accessing the report daily. We had just formed a …
Unlocking New Visualizations and Features In Power BI
This session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level.
How To Discover Undocumented Theme Settings in Power BI Desktop
One of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report, like colors, fonts, and many more. There are also tools on the internet that help you to create such a theme file. But, as you will see, there are some undocumente...
Animated Power BI Report to Show Average Sunshine throughout the year by Continent, Country and City
The report represents Average Sunshine throughout the year by Continent, Country and City. I have used custom charts for the animation. Below is the information of the charts used in this story. Sunburst Globemap Play axis Clustered column charts Table Slicer eyJrIjoiZGQ4MjQyYzctNDczMC00YzkwLWE5O...
Inspired in Python Community site eyJrIjoiZDhjM2M2ZjctYzNjZi00OWIwLWI5YWEtYjAxOWIwZTk2YzM0IiwidCI6IjI0YTdhMGYwLTI4ZDgtNDkxNy1iZGEyLTNiMDQ3MTIyMjViMyIsImMiOjR9
In this first post in a series called “Next Level Power BI”, I demonstrate how to create dynamic databars using a Scalable Vector Graphic. A dynamic SVG databar, icon, sparkline or prac…
Enhance the Card Visual in Power BI with Conditional Formatting
The conditional formatting can be used in many visuals in Power BI, and I have explained an example of doing it in table visual. This feature is also available in the Card Visual in Power BI, However, I have seen a very few people using it. In this short blog article, I'll explain how this…
Power BI table and matrix visuals can render SVG object elements in a column or measure to display in-line web content. You can build dynamic content like KPI indicators, databars and sparklines by…
Learn How Power BI and Accessibility Work Together
Power BI’s accessibility documentation has been expanded from one article to five new articles for you to explore. We hope that these new articles will help you learn more about how Power BI can empower your organization, report creators, and report consumers through accessibility.
Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI
In this post I show you a very quick trick to format Line Chart and Area Chart conditionally in Power BI. As this is a “Quick Tip” I’m going to keep this post really short. One of my customers asked me to show time series in line charts and area charts. But she want’s it … Continue reading Quick Tips: Line Chart and Area Chart Conditional Formatting in Power BI
I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating effective Power BI …
Build your custom visual with Charticulator and Power BI
Recently I attended an excellent session by Andy Kirk on the state of data visualization for 2019. One of the tools Andy is most excited about is called Charticulator. For...
Simply adding more visuals to a report impacts performance, In this Tutorial learn how I tested this, and learn how to prevent your report from these issues
Empower Your Story Telling Data Visualisation in Power BI with Colour Coding
This post has been waiting in my blogging list for a while and now this is my last post in 2019. I wish you all have a wonderful year ahead. In this post I discuss a very important aspect of data visualisation; Colour Coding. I believe, colour coding is one the most powerful and efficient … Continue reading Empower Your Story Telling Data Visualisation in Power BI with Colour Coding
Introducing Scrims, an elegant background for your Power BI Reports. Click hear to learn how to use a scrim to make your report shine. Click to download.
How to reduce data volume in PowerBI Maps by using WKT
In a previous blog, I showed how to load a raster tiles into PowerBI data model, in theory that should solved all my issues with doing a detailed maps in PowerBI. unfortunately, no, even if R and P…
Data Color Reference for Power BI Themes (as of December 2019) - DataVeld
Reading Time: 3 minutes Along with the updated Power BI Desktop ribbon, several additional report themes are available. The Power BI docs provide a great reference to the new options, except they do not include the specific color values for anyone who wants that level of detail. Last year, I compiled a hex color reference for the (then eight)…