Let’s dive into the world of conditional formatting in Power BI. Whether you’re a seasoned Power BI user or just getting started, understanding how to apply conditional formatting can significantly enhance your visualizations. In this blog post, I’ll cover the basics and provide practical examples. Conditional formatting allows you to dynamically change the appearance
Conditional Formatting in Power BI Read More »
Dynamic Format Strings in Power BI In this post, I’m going to show you how to use dynamic format strings in Power BI to make your measures look awesome. Dynamic format lets you change the way your measures appear in visuals based on conditions or context. For example, you can add currency symbols, abbreviate
Dynamic Format Strings in Power BI Read More »
Common Pitfalls and Errors in Power BI Report Building Power BI has revolutionized the way organizations manage data visualization and reporting. With its powerful capabilities, it enables users to create insightful and interactive reports. However, even seasoned professionals can fall into common pitfalls that can hinder the effectiveness of their Power BI reports. In this
Common Power BI Reporting Mistakes Read More »
Matrix vs Table in Power BI In this blog post for Matrix vs tables in Power BI, I will compare and contrast the matrix visual and the table visual, and show you how to use them effectively in your reports and dashboards. Both visuals are useful for displaying tabular data, but they have some key
Matrix vs Table in Power BI Read More »
PowerPoint and Power BI Today we will be discussing the amazing feature of having Power BI visuals live in your PowerPoint presentations. This feature is now generally available and I believe it’s a complete game changer. I have certainly seen some of my report visuals being butchered in a PowerPoint, because the users had no
PowerPoint and Power BI Read More »
Data Bear’s Monday Motivation Blog Post Welcome back to another post to help you on your Power BI journey. Today is a blog about some tips to create fun professional-looking buttons in Power BI. You can use buttons for navigation between report pages, switch between visuals, or even URL links. 1. Navigation buttons in Power
Buttons in Power BI Read More »
Data Bear’s Monday Motivation Blog Post Today I will be showing you the dilemma I had about adding targets in Power BI for KPI’s in my dashboards and how it was approached. My scenario was this. I had Sales data over different countries and monthly targets for each are set and should be added to
Adding targets in Power BI report Read More »
Data Bear’s Monday Motivation Blog Post Happy Monday all. Today I’ll be showing you the unpivot function in Power Query. This is a very helpful modeling tool that helps you shape your data in a more user-friendly way. It transforms (no pun intended) your visual representation options. We all know that data is messy and
Power BI: Unpivot in Power Query Read More »
On numerous occasions, I’ve been asked if it’s possible to create separate views of the same dashboard dependent on a user’s Power BI credentials? This is possible through Power BI’s Row-level security (RLS). With RLS we are applying security on the underlying data of the dashboard, so when we open the dashboard, Power BI will
Power BI Tips: Using Row Level Security Read More »
In order to offer meaningful insights from data analysis work in Power BI, it is commonly necessary to perform complex calculations involving all kinds of metrics, sub-totaling functions, data filtering, and relationship handling. For the experienced Power Pivot – Power BI user, the Calculate function of the DAX engine is by far one of the
Power BI Tips: Calculate | One of the most used DAX functions Read More »
