I have previously written articles about how you can write a measure in DAX that helps with TOP N filtering. However, you may not need that calculation for many situations. If all you want is just simply to get the top 10 customers based on the sales amount, or bottom 5 products, etc, then you Read more about TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter[…]
Power BI is a mobile-friendly reporting solution. Every report that you generate can be viewed on the Mobile too. However, it doesn’t mean that the report is designed for mobile, or in other words; it doesn’t mean that is it a mobile report page. You have to make some changes, and take some extra considerations for Read more about Power BI Design Tip; Design for Mobile Device[…]
Like many other services and tools in the market, when a product passes certain popularity, normally we see some rumors and myths and misconceptions about it spreading around. Power BI also has that kind of myth and misconceptions. In this article, I’ll uncover five of the most common myth and misconceptions about Power BI. Video Read more about Top Five Myth and Misconceptions about Power BI[…]
A question I often get from many students is: “How can I practice Power BI service features if I do not have a Power BI Account?”. Not having a Power BI account can happen because of many scenarios; your company might close this option so that the process be only channeled through a specific process Read more about Power BI Sandbox: An Environment to Learn Power BI Service for Free[…]
A question that I often get when I explain what the dynamic row-level security in Power BI is and how it works, is that; how can we get all the users in an Active Directory tenant imported into Power BI? There are other benefits also to import Azure Active Directory (AAD) users loaded into Power Read more about Import Azure Active Directory Users into Power BI; An Step toward Dynamic Row-Level Security[…]
So you want to become a Power BI Developer, and wonder what skills you need to learn, what are the best resources to learn from, and where to start? This is an article and video explaining those in detail and helping you in your journey to become a Power BI Developer. Video 1. Data Modeling Read more about Skills Needed for a Power BI Developer[…]
It happens that you might have two fields as From and To date (or Start and End date) in your dataset, and you want a date slicer in the report. The date slicer has to filter records in a way that the FROM and the TO dates are in the range of dates selected in Read more about Power BI From and To Date Filtering with One Slicer[…]
Power BI can get data from Google Sheet now. This functionality is released just yesterday and announced in both Power BI and Power Query blogs. The feature is still preview (Beta) but it is worthwhile looking at how it works in a quick article and video. Video Google Sheet’s URL To get data from a Read more about Power BI Get Data from Google Sheets[…]
I have previously written about conditional formatting in Power BI, and how you can take one step further with using DAX to dynamically change the conditional formatting. Conditional formatting with DAX for colors is easy, you can use the color name or their hex code. But for Icons, it is slightly different. You can either Read more about Power BI Icon Names for Conditional Formatting Using DAX[…]
It happens often in Power BI calculations and reports that you need to concatenate a list of values from a column. You can do this concatenation in Power Query or DAX. However, if the concatenation needs to be done dynamically. ConcatenateX is a very helpful DAX function to achieve such results. It is very helpful Read more about ConcatenateX in Power BI and DAX: Concatenate Values of a Column[…]