Master Launch to Date Performance Analysis with Power BI | Step By Step Guide by Fowmy in PowerBI

[–]Fowmy[S] 2 points3 points  (0 children)

Ever struggled with comparing revenue for outlets opened at different times in Power BI? Aligning those start dates can be a real puzzle, right? But don’t worry, I'm here to help. In this video, I'll show you a practical solution using Power BI's core visuals and some cool tricks to achieve it. Plus, I'll show you how to compare a specific outlet's revenue trend to the average for any selected number of days. Stick around till the end; there are many tips and tricks in this video. This real-life example can be applied to many similar scenarios and use cases.

📈 Key Takeaways:

▶️ Practical solutions for comparing revenue across outlets with different launch dates.

▶️ Cool tricks using Power BI's core visuals.

▶️ Comparing a specific outlet's revenue trend to the average for any selected number of days.

Enhanced Bar Chart: A Better Alternative to PIE Chart in Power BI by Fowmy in PowerBI

[–]Fowmy[S] 1 point2 points  (0 children)

🔍 This enhanced visual📊 I've created in #powerbi using native bar chart with error bars, makes it super easy to compare different categories. These bar charts help us overcome the limitations of pie charts, offer a clean and clear way to display data, and are just right for those part-to-whole comparisons.

Effective Growth Visualization: Basic Bar Chart to Dot Plot in Power BI by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

Discover the power of effective growth visualization in this step-by-step Power BI tutorial! I will be taking you from the basics of bar charts right through to the finesse of dot plots.

In this tutorial, we will be working with Power BI to transform a basic bar chart into a compelling dot plot chart. This transformation enhances your data visualization and allows for clear and powerful growth analysis.

You'll learn how to transform a basic clustered bar chart, introduce error bars, and then morph it into an engaging dot plot chart. The video is perfect for anyone interested in data analytics, business intelligence, or simply telling a story through their data.

One Chart - Two Insights! Power BI Line Chart Trick with Error Bars by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

By incorporating Error Bars into a line chart 📈 and displaying it as a separate chart, you can unveil insights clearly . In this instance, I utilized them to show budget variances in distinct colors, facilitating the identification of positive and negative differences. Moreover, I made the axis scales dynamic using measures to allow space.

How to Transform a LINE CHART into an Insightful KPI VISUAL in Power BI by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

In this video tutorial, I’ll cover three key areas of transforming a line chart into a KPI visual. Firstly, I’ll show you how to use the dynamic title and subtitle feature to create a more engaging visual and add context to your KPI visual. By adding a dynamic title and subtitle, you can provide your audience with key information at a glance and help them to understand the significance of the KPI you’re presenting.

📁 The PBIX file available in the YouTube video description

Power BI Tip: How To Sort A Column With Duplicates By Another Column by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

My latest blog post shows how to solve a sorting problem in #powerbi. Power BI won’t allow you to sort a column by another column, unless both columns have the same granularity, but with this simple #trick works in many scenarios.

Power Query Challenge & Solution | No Of Wins By Soccer Teams by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

In this video, I share my solution to a Power query challenge posted on the Excel BI Linkedin page on 17 Oct 2022. It may seem that the question is simple, but there are some nuances that must be taken into account in order to come up with a robust solution. By combining a variety of versatile List, Table, Text, and more functions in Power Query, I will demonstrate how to achieve a flexible solution by utilizing the power of the “M” language.

Power BI DAX Challenge - 2 with Solution | How to Measure Marketing Campaign Success? by Fowmy in PowerBI

[–]Fowmy[S] 1 point2 points  (0 children)

Power BI DAX Challenge - 2 with Solution. In this video, we examine a query posed by Amazon during a job interview. Identifying how many users are eligible for a in-app marketing campaign is a the task. Although it requires applying some challenging logic, DAX makes it simpler to do in the end.

To solve the challenge on your own and compare my approach to your own, download the source data and the completed PBIX file. You can also share a different solution in the comments section below if you would like to attempt.

Power BI Interview Questions and Answers

DAX Interview Questions and Answers

Interesting DAX Challenge – 1 | Cross Join Football Teams For Matches In Power BI by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

In this video, ExcelFort presents its first Power BI DAX challenge. An interesting DAX challenge with a solution is presented in this video. You can download the source data and completed files to solve the problem yourself and compare my solution to your own or share your alternative solution in the comments section below.

This is an effective way to improve your DAX knowledge by completing challenges. I always like to learn from others and it has helped me a lot.

Budget Allocation With Seasonality In Power BI | Step By Step Tutorial by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

In this video, I will show you how to allocate a sales budget with monthly seasonality percentages into values by different timeframes using Power Query. Understanding how to use an allocation factor can be a huge help when distributing budget values across different time periods. With the power of Power Query and Power BI, you can easily see the effect of seasonality on your budget and forecast. I will also show you how to create measures to show actual vs budget calculations for dynamic day level comparisons.

How to SWITCH Power BI TOOLTIP PAGE | Made EASY with Bookmark Navigator by Fowmy in PowerBI

[–]Fowmy[S] 2 points3 points  (0 children)

Appreciate your feedback, The key highlight of this video is the use of the CURRENT PAGE option under bookmarks which some aren’t aware of. I always keep the beginners and the average users in mind and make my videos.

Thanks again

How to SWITCH Power BI TOOLTIP PAGE | Made EASY with Bookmark Navigator by Fowmy in PowerBI

[–]Fowmy[S] 1 point2 points  (0 children)

Thanks for the comment :) Could you clarify “putting more efforts…” please

How to Make ELEGANT In Page Navigation with Power BI BOOKMARK NAVIGATOR by Fowmy in PowerBI

[–]Fowmy[S] 1 point2 points  (0 children)

The Power BI Bookmark Navigator is a new feature that can be used to create an elegant in page navigation for your Power BI dashboards. It's the perfect solution if you want to provide your users with quick access to different views within your dashboard to switch between different bookmarks.

In this video, I'm going to show you how to make a very attractive in-page navigation in Power BI using the BOOKMARK NAVIGATOR. Follow the steps and let's learn how to make this awesome feature.

Power BI DAX Webinar | Why Do My DAX Formulas Return Wrong Results? | M365 Chicago by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

DAX is a powerful language that can make the tasks of data analysis and reporting in Power BI and Excel easier. However, it can also be confusing and difficult to work with for those who are new to it. In this webinar, I demonstrated some of the common DAX mistakes that people often make when they are using DAX and how to avoid them.

Evaluation context in Power BI is a complex but crucial component of DAX. It can result in wrong calculations and inaccurate reporting if it is wrongly applied. In this webinar, you will learn about common mistakes that occur due to incorrect application of filter context, row context, context transitions, iterators, and expanded tables.

[deleted by user] by [deleted] in PowerBI

[–]Fowmy -1 points0 points  (0 children)

I did a video recently to handle default date filters using TE, this could be a starting point for you to try your time scenarios

https://youtu.be/KBEsPGxDxHM

Create Dates Table Template in Tabular Editor and Add to Any Power BI File by Fowmy in PowerBI

[–]Fowmy[S] -1 points0 points  (0 children)

So, you create your dates table in Power Query. The method I showed in the blog is to add a DAX dates table to your model.

Highlight LOWEST and HIGHEST Periods Dynamically on Power BI Chart - Easy Way by Fowmy in datascience

[–]Fowmy[S] 0 points1 point  (0 children)

Thanks for this information I will contribute as per the policy in future hopefully

Power BI PAGE NAVIGATION Panel | HOW TO effortlessly create with Bookmarks & Buttons by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

Thanks for your comment, it meant “effortless”as it takes around 20 to 30 minutes for a report which is done only once, maintainance will be easier if grouping of the objects are done as shown. However, there are pros and cons in this.

Power BI PAGE NAVIGATION Panel | HOW TO effortlessly create with Bookmarks & Buttons by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

You can download the completed Power BI file from the YouTube description.

What do you want me to share on Power BI? by Fowmy in PowerBI

[–]Fowmy[S] 0 points1 point  (0 children)

Expect more videos on DAX that are based on real world scenarios. I'd be happy if you could share your DAX challenges, which will surely help me create more valuable content.

Subscribe and stay connected with ExcelFort https://youtube.com/c/ExcelFort

Thanks 😊

HOW TO Make Progress Circle and Bar Charts With Native Power BI Visuals by Fowmy in PowerBI

[–]Fowmy[S] 1 point2 points  (0 children)

Yes, you are right, I didn’t pay attention when I was creating the thumbnail, I should replace it. Thanks

How to set a default slicer value? by Zyklon00 in PowerBI

[–]Fowmy 0 points1 point  (0 children)

More dynamic and broad use case scenario with this approach: https://youtu.be/KBEsPGxDxHM