The most recently updated SharePoint, Power Apps, Power Automate and Power BI tutorials from EnjoySharePoint. Every tutorial is tested in a real Microsoft 365 tenant.
A regional sales report I built had four pages, and every page needed to show only the East and West regions, while one chart on the first page should only list products above $80,000. Both requests are filters, just at different levels, and choosing the right level saves you from repeating the same filter on … Read more >>>
A Power BI report can have perfect data and still fail. If the charts are cluttered, the colors fight each other, and the numbers show seven decimal places, people stop trusting it, or they just stop opening it. Good Power BI visual formatting fixes that and turns a working report into one your managers actually … Read more >>>
Have you ever tried applying conditional formatting to your Power BI Matrix visual? That makes your data more engaging and easier to understand. You can add background colors, font colors, data bars, icons, or web links to your matrix visualization to highlight the data. In this tutorial, I will explain how to apply conditional formatting … Read more >>>
I recently worked with a client who needed to customize the visuals in their Power BI reports to reflect their business data better. Changing visuals in Power BI is a powerful way to enhance data presentation and make your reports more insightful. In this tutorial, I will show you how to change the visual in … Read more >>>
Recently, while working on a report, I was required to show multiple values by grouping them together. I researched this and found that a Power BI clustered bar chart is the best option. Even while doing a little more research, I found out that we can also do a lot of formatting in it, like … Read more >>>
Do you want to display multiple legends in the Power BI stacked column chart? This Power BI tutorial will explore how to achieve this by implementing a dynamic legend. Unfortunately, the Power BI Stacked column chart does not support adding multiple legends. However, I got an idea; we will create a dynamic legend. Instead of … Read more >>>
I recently worked for a client who asked me to create a bar chart showing sales based on segments with data labels. Yes, we can do it. Then, another requirement came to show the sales value in percentage value in the bar chart data labels. I researched this and found that we can show percentage … Read more >>>
Recently, I was working on a Power BI report for a client. The report is based on the ‘Product Sales and Profits’. As one of their requirements was to view the profit of different product categories each year, which should show the category with the highest profits, and also the category with the lowest profits. … Read more >>>
Do you want to learn how to use a matrix visual in Power BI? I will help you with some Power BI matrix examples. In this Power BI tutorial, I will explain Power BI Matrix visualization. Along with this, I will also cover some more topics mentioned below: What is a Matrix Visual in Power … Read more >>>
Row-level security (RLS) in Power BI lets you show the right rows to the right people without creating separate reports for each user or region. In this tutorial, we’ll walk through what RLS is, when to use it, how to set it up (static and dynamic), and some best practices. What is Row-Level Security in … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to