RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Power BI Datamart – What is it and Why You Should Use it?

One of the newest additions to the Power BI components is the Datamart. Power BI Datamart is more than just another feature, it is a major milestone where the development of Power BI solutions will be revolutionized based on that. This is a feature that helps both citizen data analysts and developers. In this article Read more about Power BI Datamart – What is it and Why You Should Use it?[…]

Power BI DAX: Previous Month-to-Date, Quarter-to-Date, and Year-to-Date Calculations

If you want to compare the sales up to a particular day and compare it with the previous period (month, quarter, or year) but up to that particular day in that period, then it is called previous month-to-date, previous quarter-to-date, and previous year-to-date. These calculations can be more helpful than comparing with the entire period Read more about Power BI DAX: Previous Month-to-Date, Quarter-to-Date, and Year-to-Date Calculations[…]

Set Power BI Data Color: All Visuals to Follow Same Color for the Same Data Point

You can set the color in every visual in Power BI easily. You can also set the color of multiple visuals at the same time using Themes. However, what if you want to set the same color for the same data point? For example, You want the Gender Female to be always colored Orange in Read more about Set Power BI Data Color: All Visuals to Follow Same Color for the Same Data Point[…]

Top Five Mistakes to Avoid When Developing Power BI Reports

Because Power BI is an easy-to-start platform and you don’t need an extensive learning curve to get started with Power BI Desktop, we often see some bad practices in the implementation of Power BI reports. In this article and video, I explained the top five mistakes that I see happen a lot in building Power Read more about Top Five Mistakes to Avoid When Developing Power BI Reports[…]

PL-300: Power BI Exam Prep: Connecting to data sources

If you want to pass the PL-300 exam, there are some areas in that your skills will be assessed, and one of those is identifying and connecting to the data source and changing data source settings. Power BI Supports over 140 data sources, each data source has some connection configurations. Below you will learn the Read more about PL-300: Power BI Exam Prep: Connecting to data sources[…]

Power BI Subscription: Get Report Updates In Email

Have you ever wondered is it possible to have updates of the Power BI report to be emailed to you (or some other colleagues) on a daily basis? Power BI, fortunately, has this feature, it is called Subscription. Subscriptions are helpful ways to send an up-to-date version of the report and dashboard to the users’ Read more about Power BI Subscription: Get Report Updates In Email[…]

TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter

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 Design Tip; Design for Mobile Device

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

Top Five Myth and Misconceptions about Power BI

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