Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table Pattern

The trick I am about to explain in this article is used in many samples, and it is not a new trick. However, it is very useful, and many Power BI users are still not aware of it. Let’s say you have to columns: Cost, and Sales, and in one chart, you want to show Read more about Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table Pattern[…]

Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report

I have previously written a method explaining different ways of getting the local timezone. However, that method was only for a scenario with users all in one timezone. What if your users are in different time zones? what if you want to show them information in the local timezone for each user? In this article, Read more about Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report[…]

What Do You Need to Implement Dynamic Row-Level Security in Power BI?

I have written some articles on the RLS topic already. Through my consulting experience, however, I get the feeling that many people can’t easily move from static RLS to dynamic. If you know what are things you need to have the dynamic RLS implemented, it makes the whole process simple. So this is what I Read more about What Do You Need to Implement Dynamic Row-Level Security in Power BI?[…]

Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security

In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to Read more about Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security[…]

Show the information but not the details: Power BI Data Masking

I wrote several row-level security articles so far, and a book. I explained how to restrict access to the data using row-level security approaches. However, one of the questions I got recently is this: “I want users to see one another’s sales information, but not to see who others are! How can I do that Read more about Show the information but not the details: Power BI Data Masking[…]

How to Use ALL in a DAX Expression in Power BI

I have previously written a blog post about what the ALL function in Power BI is, and how it helps in working with filters in your report. However, still I get many students confused about how to use this function, which parameter to pass to it. This blog post is explaining that in detail. Why Read more about How to Use ALL in a DAX Expression in Power BI[…]

Get the Day of the Week Name and Number in Power BI Using DAX

If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX[…]

Power BI DAX Back to Basics: Scalar Vs. Tabular Functions

DAX is the analytical language in Power BI. Learning this language, however, comes with some difficulties. Part of that challenge is the way that functions work in DAX. Learning the output of functions is an important element of learning how and where you can use them. In this article, I’ll explain two types of outputs Read more about Power BI DAX Back to Basics: Scalar Vs. Tabular Functions[…]

Substring in DAX: How to get Part of String Field in Power BI Using DAX Expression

Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from “Reza Rad”, if I want to get the Read more about Substring in DAX: How to get Part of String Field in Power BI Using DAX Expression[…]

Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer

Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters, Read more about Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer[…]