More than a year ago, a question was asked on the Power BI community in regards to showing a heat map in Power BI. Not just a simple heat map in the matrix visual, but a heat map based on data smoo…
Dynamic title/measure based on what is NOT chosen in a #powerbi Slicer
A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…
Restrict number of data points in Power BI visuals
Sometimes we have data for many years in our dataset, but we want to restrict how many data points we want to show in #powerbi visuals at any given point. In this blog post, I talk about how you ca…
Show values in a chart only when a slicer is selected
Quick one today. This question came up recently: “I only want to show values in a chart when someone selected a slicer”. Now this is actually not that hard, so...
Want a custom legend for your power bi visual watch this
Do you need a custom legend for your Power BI visual and not sure how to put one together? Have a look at how you can build a legend for your conditional formatting. Download sample
Share Different Visual Pages with Different Security Groups in Power BI
I have written a dozen of blogs and a book about Power BI row-level security and the security on the dataset. However, I always get this question that: "What if I want some people to see only a few pages of my report, and some others to see other pages?" or "How can I put…
In December of 2019 Power BI team updated the KPI visual with a ton more features and options. This tutorial walks us through all the new hot features.
Get the Image URL in Power BI Using Power Query Get Table from Example
I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. There is an…
Dynamic X-Axis Reference Range, With Threshold-Based Shading
This is a mock-up in response to this question on the Power BI Community Boards and provides a concept for expansion rather than telling a particular story. This is an example building on Parker Stevens' excellent Dynamic Reference Line on X-Axis walkthrough, with a twist. Rather than having a singl...
A Primer for the Microsoft Power BI Color Picker - DataVeld
Reading Time: 3 minutes With the December Power BI Desktop update, users are introduced to a new color picker when customizing theme colors. The new color picker is much more versatile than the original when selecting colors. Power BI’s new custom color picker (seen in theme customization preview): Power BI’s original custom color picker (currently seen everywhere else): …
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)…
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…
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.
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
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
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...