Many of you have asked how they can learn power bi or how they can improve the skills they already possess in power bi. There are over 500 videos on my channel of which around 400 are on Power BI in English and another 50+ are on Power BI in…

Power BI released field parameters in May 2022 and I have discussed the feature in detail in my blog post as well as in my video. Additionally, I have shown you how this feature allows you to switch measures as well as do conditional formatting based on requirements. Power BI…

Problem Statement: We would like to display the top 5 or the Top 10 with others. Other than the top 5/10 items, the rest are grouped into others. Solution: This solution requires us to use the extended dimension approach we have used in some of our previous blogs, such as…

Problem Statement: In a slicer, we have a set of values. If a value is selected, then show the unselected values as others. Solution Approach: There are two ways in which we can solve this problem: by adding additional dimensions or by using extended dimensions. In this case, we are…

If you use power bi direct query, you can define a date table at the source or in power bi. You can create a date table in Power BI. The table created in Power BI is in import mode. Power BI will enable mixed-mode queries. You can refer to my…

Problem Statement: Table 1 has date ranges and table 2 has dates. We need to add a new column in table 2 which provides us with the count of rows that contains this date in table 1. In case of a null value consider today's date. …

I have organized a webinar on 12th November 2022 on the topic: How to get help on Power BI. Advantage of helping on Community Following are the speakers, Vijay was not able to join Ashish Mathur Mohammed Adnan Vijay Perepa Amit Chandak These experts have the following blogs/Channels Ashish Mathur Mohammed…

Problem Statement: We have been given a text column with some comma-separated values. A slicer on each such text part should be able to filter the table. In the data given below, we would like to have a slicer on A, B, C, D

Problem Statment: A series of tests have been performed on individuals. And test status and their values are given in different columns. We would like to get the max/min value of tests for each individual where the test status is yes. The Data: