RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Generating Row Number in Power BI Visualization Using DAX

I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let’s see how this is possible. Sample model I have a Read more about Generating Row Number in Power BI Visualization Using DAX[…]

One Dimension Filters Another Dimension in Power BI

I often get this question after I explain about the star-schema. The question is that both my dimensions are filtering my fact table values, but how can I get one dimension filtering another dimension? for example, how can I get only the list of products that have been purchased by this customer? In this article, Read more about One Dimension Filters Another Dimension in Power BI[…]

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[…]

Power BI Is Too Much for One Person: Roles in the Power BI Development

Power BI is a tool that you can get started working with it in a few hours, but to use it in its full potential, these days, you require to have many skills. The variety of solutions and BI implementations is also dictating to have different roles, positions, jobs in the Power BI development market. Read more about Power BI Is Too Much for One Person: Roles in the Power BI Development[…]

How to Use Time and Date Dimensions in a Power BI Model

I have written a blog article about the date dimension, and also one about the time dimension. However, I got some questions in the comments about how they will be used together in a data model. In this article, I’ll explain that. Date Dimension The date dimension or calendar dimension is one of the most Read more about How to Use Time and Date Dimensions in a Power BI Model[…]

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[…]

Text Entity Extraction in Power BI, Text Analytics Service

Another service to Microsoft Cognitive Text Analytics API is Text Analytics API, which is about Entity Linking, and Named Entity Recognition (NER). Entity Linking: Entity Linking able to identify the disambiguate the identity of an entity found in the text (for example, determining whether an occurrence of the word Mars refers to the planet, or Read more about Text Entity Extraction in Power BI, Text Analytics Service[…]