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[…]
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[…]
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[…]
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[…]
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[…]
So you want to add a sparkline in a Power BI report and wonder how to do it. Fortunately, the Power BI team recently added that functionality, and it is very easy to use. In this blog and video, I’ll explain how it works through a demo. Video What is the Sparkline? Sparkline is a Read more about Sparkline in Power BI[…]
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[…]