Calculate Totals in Power BI: Using Iterators in DAX

The total value that you see in a table is not actually SUM of all values in that column, it is, in fact, the calculation, when there is no filter. This, however, might not be the calculation that we want sometimes. we might want this value to be the sum of values of that column Read more about Calculate Totals in Power BI: Using Iterators in DAX[…]

Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query

I am excited about this blog post, this is based on the New service in Cognitive Service name “Anomaly Detection” which is now in Preview. I recorded a video about how it works in cognitive service https://youtu.be/7ZOtZDbn6gM.  However, I am going to talk about how to use it in Power BI. In this post first, a Read more about Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query[…]

Same Period Last Year to Date DAX Calculation in Power BI

I have previously written about how to calculate the same period last year calculation and compare this year’s values with the last year’s values. However, sometimes, you don’t yet have the full year, especially for the current year. You might want to compare this year’s value with the last year’s value up until the same Read more about Same Period Last Year to Date DAX Calculation in Power BI[…]

Pre Concatenate List of Values in Power BI using Power Query

You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I’ll explain how this works. If you like to learn more Read more about Pre Concatenate List of Values in Power BI using Power Query[…]

Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases

I have written about both types of parameters in Power BI; Power Query parameters and also the What If parameters. However, still many people are not aware that these two are different, and serve different purposes. In this blog article, I am explaining the differences between these two types of parameters, as well as the Read more about Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases[…]

Power BI What If Parameter for Getting the Sales of X months ago: Use Case Scenario

There are two types of parameters in Power BI, Power Query parameters, and What if parameters. In this article, I’m going to explain a very useful use case of the what-if parameters, and if you haven’t ever worked with it, it is a great way to understand what is What If parameters and what things Read more about Power BI What If Parameter for Getting the Sales of X months ago: Use Case Scenario[…]

Slicer with AND condition in Power BI

The default behaviour of the slicer in Power BI is that it shows the result of OR when you select multiple items. For example, if you have a slicer for product colour, and then you select both “Black”, and “Blue” the result would be all records that have “Black”, OR “Blue”. Of course, you won’t Read more about Slicer with AND condition in Power BI[…]

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters

Parameters in Power Query are useful for many scenarios when you want to do something dynamic in the data transformation process. I have previously explained how helpful they are in creating a custom function. In this article, I am showing you another useful way of using Parameters to create dynamic datasets, that you can change Read more about Change the Source of Power BI Datasets Dynamically Using Power Query Parameters[…]

Enhance the Card Visual in Power BI with Conditional Formatting

The conditional formatting can be used in many visuals in Power BI, and I have explained an example of doing it in table visual. This feature is also available in the Card Visual in Power BI, However, I have seen a very few people using it. In this short blog article, I’ll explain how this Read more about Enhance the Card Visual in Power BI with Conditional Formatting[…]

Calculating Total, and Percentages in a Row-Level Security Power BI Model

I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare Read more about Calculating Total, and Percentages in a Row-Level Security Power BI Model[…]