Power BI

The Pareto chart or diagram analyzes the frequency of problems or causes in a process. Learn about the other 7 Basic Quality Tools at ASQ.org.

Tutorial: Create a decomposition tree visualization in Power BI

In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how…

This is a blog post series to show various ways of creating parts of landing pages for better UX and navigation Tiles using, Images, Power BI buttons, hover effects and all the above…

Recently, I was asked by my supervisors to hide the column header ‘Over/Under’. There are a few ways to solve this, and I will show you my approach. Below is my table before and after. Steps We want the name of the ‘Over/Under Field’ to be blank. If you try to erase the verbiage on […]

Learn about using mapbox inside power bi with this excellent free tutorial from Alice Drummond. This tutorial is a quick getting started example.

BeComments - Add your comments to your Microsoft Power BI report and link it with your data! Add formatted text, images and even videos!

This article describes how to use conditional formatting with a DAX expression to color the rows of a table in Power BI based on the order number instead of

What is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across several screens (e.g., a step-by-step signup flow). The purpose is to lower the…

To build something like this in Power Bi, we don’t need any custom visuals or excessive coding experience. Just a little bit of thinking out of the box :) In Range Bar Charts, data points are built starting from the minimum values per category.

I came up with this concept while working on the front end of the Regional Emergency response solution. When trying to templatize some work that was done for a specific customer, I realized that th…

For users accustomed to pivot tables and charts in Excel, Power BI now has a pivot-like experience built-in. Personalization is available in the Power BI Service for any end user once enabled for a report.

This month we are incredibly excited to announce a new visual personalization feature to allow your end-users to explore and personalize visuals all within the consumption view of a report! Check out the full blog post to learn more.

I see lots of chatter on Twitter and other media about the use of “small multiples” as a great way to communicate information across different subsets of data – yes Jeff Weir(d), that means you. I thought I would write a quick article about the concept to draw your awareness [...]Read More »

Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks were portrayed more as some saved views, which can be used…

How to set up dynamic page navigation and drillthrough in Power BI.

I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. Chart from Fitbit showing my step count from April 1 through May 23. The graph is from Fitbit. It…

Learn how you can take conditional drill to the NEXT LEVEL in Power BI Desktop with buttons. Patrick also shows how you can add in dynamic page navigation as well. Download Sample: https://guyinacu.be/condrillsample 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.co...

Video by: Reid Havens Learn how to add a different image to each button state in Power BI. Creating rich interactive buttons for the end user experience . Links/Resources: Curbal: The Ultimate Button Resource Travis John's Falcon Toggle Button

I was recently brought into a report design review to see what we could do about performance of the report page load. The model was optimized and the DAX was running very quickly, but they were see…

I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…

I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast ratio and get advice on how the two c…

Choosing good colors for your charts is hard. This article tries to make it easier.

To start – this problem is fairly common, but also pretty niche. If this scenario does not work for you, hopefully it will at least spark some ideas on how to use conditionally formatted butt…

Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. In this example, I am using Carbon dioxide emission data for each…

Recently, Dave Ruijter posted a blog about a library containing all the Azure Icons. He shared all icons in his GitHub repository which allows you to directly connect it to the tool Diagrams.net (p…

Drill through from cards is a common requirement in Power BI reports. In this blog post, I'm showing two ways to configure it.

Back in May, we released a public preview of a new personalize visuals experience. With this new capability, you can empower your end-users to explore and personalize visuals all within the consumption view of a report. For example, your end-user can change a measure, a dimension, or the visualization itself. Now this month, we are excited to announce that the feature is now generally available!