We have all heard of Real-Time solutions before. But each of them come with challenges. Either configuration is complicated or involves coding/ETL or the cost is exorbitant. Data Mirroring in Microsoft Fabric is none of the above. It is easy to configure, involves no ETL and the cost is minimal. This feature is in public … Continue reading Data Mirroring – Real-Time data replication
Tag: PowerBI
Power BI Copilot In Action: Enhancing Analytics with AI?
Is it too early to start a meaningful conversation about #Microsoft #Copilot for #PowerBi? Check out this detailed review video with some insightful food for thought at the end. This video is a must-watch for anyone interested in #salesreporting, #financialanalysis and #financialreporting. Let's #getsmartertogether with #msfabric and #mspowerbi! https://youtu.be/V4_krwqFArg
What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
Power BI & DAX: How to Implement Dynamic Page and Chart Titles
We often need to have a dynamic title (page or chart level) that changes based on what the user has selected from the different slicers/filters on the page. In this video, I go over several strategies for accomplishing this task. I start with a very simple one, that requires no knowledge of DAX and then … Continue reading Power BI & DAX: How to Implement Dynamic Page and Chart Titles
Price Volume Mix (PVM) for Revenue Variance Analysis
EDIT 2021-01-12: the latest post and a video on how to calculate a perfect PVM is available here: DAX for the Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) EDIT: the most recent post about this topic (and a video) can be found here: https://businessintelligist.com/2020/11/20/the-definitive-guide-to-price-volume-mix-calculation-pvm-in-power-bi-theory/ The first time I covered PVM for Revenue analysis, … Continue reading Price Volume Mix (PVM) for Revenue Variance Analysis
business intelligist 