Trending February 2024 # How To Use Chat Gpt For Power Bi: It’s Easy! # Suggested March 2024 # Top 9 Popular

You are reading the article How To Use Chat Gpt For Power Bi: It’s Easy! updated in February 2024 on the website Kientrucdochoi.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested March 2024 How To Use Chat Gpt For Power Bi: It’s Easy!

In today’s data-centric world, effective data analysis and visualization are crucial for individuals and business users to succeed. Microsoft Power BI offers superior tools, interactive visualizations, and unmatched business intelligence capabilities, but can things get better?

Welcome to Chat GPT. You can now use Chat GPT for Power BI to ask questions about your dataset, write formulas for complex calculations and request steps for implementing a particular functionality.

This is a game-changer, let’s dive into it.

Power BI has a variety of features that can take time to learn. If you’re new or unfamiliar with certain aspects, using Chat GPT’s guidance can help you make the most of Power BI, quite quickly.

Chat GPT has been trained on massive datasets and allows you to ask questions in natural language, receiving detailed and useful responses. By combining ChatGPT with the data visualization power of Microsoft Power BI, you can unlock a wealth of opportunities for generating insights and boosting your organization’s decision-making process at scale.

Now that you understand the importance of using Chat GPT alongside Power BI, let’s take a look at the main areas where Chat GPT can help you improve your data analysis and visualization capabilities.

ChatGPT is a natural language model which means that you can ask it any questions you would like an answer to, well just about.

ChatGPT can help you in the following 4 ways.

Data Preparation

Data Transformation

Data Analysis

Data Visualization

In the sections below, we will look at each step of the data analysis cycle and focus specifically on how it can improve your speed and efficiency in creating a killer Power BI report.

Join 43,428+ others on our exclusive ChatGPT mailing list; enter your details below.

Data Preparation and Transformation refer to the process of cleaning, organizing, and converting raw data into a structured and usable format, suitable for further analysis, modeling, or visualization.

They are crucial steps in any data analysis cycle and can take time, often a considerable amount. ChatGPT can help you with cleaning and transforming data in Power Query, and write custom code calculations for creating solid data flows too.

So, restart power bi desktop, and let’s get into it.

In Power BI, Power Query is a powerful tool for data transformation. It allows you to connect to various data sources, apply filters, and perform numerous formatting tasks.

To demonstrate how to use ChatGPT for Power Query formulas and code, we will use a dataset to look at specific examples to give you a more solid grounding on making your next transformation.

Once the data is loaded, you should see the following dataset in your Power BI’s Data View.

In Power Query Editor, you will see the dataset you are analyzing.

Let’s say we want to apply a filter on the Country column in the dataset. If you’ve never worked with filters in Power BI Desktop before, you can ask ChatGPT, and it will guide you every step of the way.

I entered the following prompt into ChatGPT when I was applying a filter on the Country column.

Ok, I know, I wasn’t so polite, but I wanted to get straight to the point.

ChatGPT gave generated the following detailed list of steps to follow:

Let’s follow each of these steps and see if we can apply a filter on the Country column.

After following the steps given by ChatGPT, I was able to remove rows that had Germany in the Country column.

Suppose we want to combine the columns Month Number, Month Name, and Year into a single Date column.

The following prompt was used to generate a step-by-step response using ChatGPT to replicate in Power BI Desktop:

The following guide was suggested by ChatGPT for merging the columns.

With the steps suggested in the guide, the columns were successfully merged to create a new column named New Date.

The above two demonstrations should give you an understanding of how to use ChatGPT to make more efficient data preparation and transformation.

In the section below, we will look at how to use ChatGPT to generate formulas and calculations for your Power BI reports.

Let’s get into it!

DAX (Data Analysis Expressions) is a formula language used to create custom calculations and aggregations in Power BI. By leveraging DAX, you can create complex measures and calculated columns for your data model.

For a demonstration of using ChatGPT for DAX code, we will use the same dataset as used in the above section.

I asked ChatGPT to help me write code for finding the total sales. The following is the text prompt and the output given by ChatGPT:

Once you get the code, you can go ahead and implement it in Power BI.

I asked ChatGPT to help me write the code for finding the Average Sales Price per Unit. The following is the text prompt and output given by ChatGPT:

Once you get the formula, you can go ahead and implement it in Power BI.

The above demonstrations are to highlight the amount of help you can get from ChatGPT when working on a Power BI project. You can ask ChatGPT to write the most complex formulas for you and it will return with a template formula that you can change according to the variables in the dataset. For instance, take a look at the formulas generated by ChatGPT below:

In short, you can ask ChatGPT to help with the following in DAX:

Creating calculated columns

Defining measures

Implementing time-intelligence functions

We’ve looked at how ChatGPT can be helpful in writing complex formulas. In the section below, we will look at how to enhance your data visualization and report-building capabilities with ChatGPT.

Join 43,428+ others on our exclusive ChatGPT mailing list; enter your details below.

A crucial stage in any data analysis project is to present your findings to relevant stakeholders. Power BI offers a strong set of tools that allows you to make appealing visuals and create summaries of your work.

Following are some of the ways where you can consult ChatGPT for making visualization and reports:

Example 1: Create a Bar Graph of Total Sales by Country

Suppose I want to find the total sales by country. I asked ChatGPT for the directions and the following response was generated:

After following the guide from ChatGPT, I was able to create the following bar graph in Power BI:

Keen to use see how we are integrating Chat GPT with Microsoft Outlook using Power Query? Check out our vid below:

Example 2: Create a Tree Map to show Total Sales by Country and Product

Suppose I want to find create a tree map of total sales by country and product. I used the following prompt to ask ChatGPT for directions:

ChatGPT generated the following step-by-step guide for creating a TreeMap:

With the steps provided by ChatGPT, I was able to create the following treemap:

The above examples should give you a good starting point for using ChatGPT with analyzing and visualizing data in Power BI.

You can also use ChatGPT for recommendations and directions about your data. In the section below, we will look at how you can use ChatGPT to ask for a recommendation and direction for your analyses.

When using ChatGPT with Power BI, it can suggest a variety of data analyses and visualizations based on the column names provided.

By understanding the context and the nature of the data, ChatGPT can recommend numerous potential insights and data exploration paths that users can follow to gain a deeper understanding of their dataset.

This functionality allows users to unlock the hidden value within their data by suggesting multiple analytical approaches tailored to the specific dataset.

For example, given a dataset with columns such as Segment, Country, Product, Units Sold, and Sales, ChatGPT can recommend analyses like calculating Total Sales by Country or Segment, identifying the most popular Products by Units Sold, or exploring Sales trends over time.

Users can also receive suggestions for suitable visualizations, such as bar graphs, pie charts, or line charts, to represent the extracted insights effectively.

Suppose I want a list of possible analyses on my dataset. After asking ChatGPT, it recommended the following list of analyses:

Power BI combined with ChatGPT presents an immense opportunity for data visualization and analysis.

By utilizing its diverse capabilities, you can harness the true potential of your data and make informed decisions that drive your business forward. BUT… and this is a big but…

Chat GPT, although proving to be really helpful, should not be fully relied upon. Sure, embrace the technology (we are) but always learn, practice, and build your skills alongside it too!

You're reading How To Use Chat Gpt For Power Bi: It’s Easy!

How To Use Instruct Gpt

InstructGPT is a powerful tool developed by OpenAI, designed to enhance the language generation abilities of the GPT model. Through reinforcement learning using human feedback, InstructGPT improves the reliability of the GPT model. It is one of the models that powers the magic of ChatGPT, enabling it to generate high-quality, natural language responses. Learn how to use Instruct GPT with me through this article.

Also read: Instruct GPT Login: How to Use InstructGPT

OpenAI created InstructGPT in response to concerns about toxic language, offering a solution to this problem. The GPT-3 language models that power the OpenAI API can perform natural language tasks with ease when provided with carefully crafted text prompts. InstructGPT, on the other hand, improves the reliability of the GPT model by taking human feedback into account. The reinforcement learning used by InstructGPT helps to mitigate the risk of toxic language by ensuring that the generated responses align with human intent.

Also read: ChatGPT 3.5 Login: An Ultimate Guide

To use InstructGPT, you need to access the OpenAI API, which is powered by GPT-3 language models. Follow these simple steps to get started:

To access the OpenAI API, you will need to create an account. Visit the OpenAI website and sign up by providing your email address, creating a username, and setting a strong password.

Once you have created an account, log in to the ChatGPT login page using your username and password. This page is where you can access the InstructGPT models and provide text prompts.

To use InstructGPT, provide carefully engineered text prompts that instruct the model to perform a specific natural language task. The text prompts should be written in English and as clear and concise as possible.

The InstructGPT models generate outputs based on the text prompts you provide. Labelers evaluate the outputs and compare them to those generated by GPT-3. This evaluation process helps to ensure that the InstructGPT models generate high-quality outputs.

To ensure the security of your ChatGPT login, follow best practices such as using a strong password, enabling two-factor authentication, and logging out after each session.

If you encounter any issues with your ChatGPT login or using InstructGPT, contact the ChatGPT support team for assistance.

InstructGPT is a powerful tool that can generate high-quality natural language responses for a variety of tasks. To use InstructGPT, you need to follow some specific steps:

Access the OpenAI API: To use InstructGPT, you need to access the OpenAI API, which is powered by GPT-3 language models. You can access the OpenAI API by visiting the OpenAI website and signing up for an account.

Create an account: To access the OpenAI API, you will need to create an account by providing your email address, creating a username, and setting a strong password.

Log in to the ChatGPT login page: Once you have created an account, you can log in to the ChatGPT login page using your username and password. The ChatGPT login page is where you can access the InstructGPT models and provide text prompts.

Provide text prompts: To use InstructGPT, you will need to provide carefully engineered text prompts that instruct the model to perform a specific natural language task. The text prompts should be written in English and should be as clear and concise as possible.

Evaluate the outputs: The InstructGPT models generate outputs based on the text prompts you provide. The outputs are evaluated by labelers who compare them to those generated by GPT-3. This evaluation process helps to ensure that the InstructGPT models are generating high-quality outputs.

Protect your account: To ensure the security of your ChatGPT login, it’s essential to protect your account from unauthorized access or malicious attacks. You can follow best practices such as using a strong password, enabling two-factor authentication, and logging out after each session.

Contact support if needed: If you encounter any issues with your ChatGPT login or using InstructGPT, you can contact the ChatGPT support team for assistance. They will be happy to help you resolve any issues or answer any questions you may have.

InstructGPT is not explicitly mentioned as being available for free download. While GPT-3 is available for public use through the OpenAI Playground, it is unclear if InstructGPT can be downloaded for free. A Reddit post discusses downloading InstructGPT locally, but no definitive answer is provided. Another Reddit post mentions that InstructGPT beta is available on the OpenAI Playground with a free trial. However, this does not confirm whether it can be downloaded for free. For accurate information on InstructGPT’s availability for free download, visit OpenAI’s official website or contact their support team.

The main difference between GPT-3 and InstructGPT is their ability to follow instructions and align with human intent. InstructGPT is an improved version of GPT-3, designed to be better at understanding and following instructions. OpenAI transformed GPT-3 models into InstructGPT models using a three-step procedure, which includes supervised fine-tuning and reinforcement learning.

InstructGPT is a powerful tool developed by OpenAI that improves the reliability of the GPT model by using reinforcement learning and human feedback. It can generate high-quality natural language responses for a variety of tasks, making it an essential tool for anyone who works with natural language processing.

Share this:

Twitter

Facebook

Like this:

Like

Loading…

Related

80 Most Useful Chat Gpt Prompts For Students To Make Most Out Of It

So, buckle up and get ready for an exciting journey into the world of limitless creativity by using these Chat GPT prompts that will help you a lot as a student.

Note: These prompts can help anyone, whether they are in high school, college, or even trying to get a PhD. To get the most out of Chat GPT, follow these prompts.

S.No.Prompts For School Students1“Explain the concept of photosynthesis in plants”2“How does Newtons Third Law of Motion apply in reallife situations”3“Discuss the causes and effects of the Great Depression of 1929”4“Outline the structure of DNA and its role in genetic information”5“What are the key features of Baroque music”6“Describe the circulatory system and its functions in the human body”7“Explain the impact of the Civil Rights Movement on American society”8“Analyze the role of enzymes in biological processes”9“Discuss the major themes in William Shakespeares Romeo and Juliet”10“Define the concept of equilibrium in chemistry and its applications”11“Evaluate the significance of the French Revolution on global history”12“Describe the process of cellular respiration in plants and animals”13“Discuss the causes and consequences of World War I”14“Analyze the symbolism in Nathaniel Hawthornes The Scarlet Letter”15“Define the laws of thermodynamics and their applications”16“Evaluate the impact of the Industrial Revolution on the economy and society”17“Describe the structure and functions of the nervous system in humans”18“Discuss the role of the United Nations in maintaining international peace and security”19“Analyze the themes in John Steinbecks The Grapes of Wrath”20“Define the properties and behavior of light including reflection and refraction”21“Can you help me solve this math equation? It’s for my algebra class and I’m struggling to understand it22“I need to complete a math project for my geometry class23“I have a test tomorrow in calculus and I need to review some formulas24“I have a math homework due tomorrow and I’m stuck on a problem25“I need to practice my math skills26“Can you help me prepare for a math quiz I have next week? I need to practice my mental math skills27“I’m having trouble understanding the concept of vectors in my math class28“Can you help me write a 3-page essay on the causes of World War II?”29“Help me summarize the events of the American Revolution in 5 sentences”30“Can you give me some study tips for understanding ancient Greek history?”31“Help me write a persuasive speech on why the Civil War was necessary”32“Can you help me understand the differences between the Renaissance and the Reformation?”33“Help me create a timeline of the major events of the French Revolution”34“Can you explain the concept of feudalism to me?”35“Help me analyze the impact of the Industrial Revolution on society”36“Can you help me compare and contrast the Roman Republic and the Roman Empire?”37“Help me write a research paper on the causes of the American Revolution”38“Can you help me explain the significance of the Magna Carta?”39“Help me write an essay on the role of women in medieval Europe”40“Can you help me understand the impact of the Scientific Revolution on modern society?” S.No.Prompts For College Or University Students41“Can you help me write a research paper on the history of the Roman Empire?”42“Help me find credible sources for my psychology essay on the effects of stress on the human brain”43“Can you assist me in creating a presentation on the economics of renewable energy?”44“Help me write a short story for my creative writing class on the theme of time travel”45“Can you help me solve this complex math problem on vector calculus?”46“Help me understand the basics of market analysis for my finance class”47“Can you assist me in writing a persuasive essay on the benefits of a vegan lifestyle?”48“Help me write a critical review on the impact of globalization on developing countries”49“Can you help me with my programming project on building a chatbot using Python?”50“Help me create a study plan for my upcoming exams in history and political science”51“Can you assist me in understanding the theories of evolution for my biology class?”52“Help me write a personal statement for my university application in engineering”53“Can you help me solve this complex physics problem on quantum mechanics?”54“Help me analyze a case study on the impact of technology on the music industry”55“Can you assist me in writing a poetry analysis essay on the works of William Wordsworth?”56“Help me create a budget plan for my personal finance class”57“Can you help me understand the concept of machine learning for my computer science class?”58“Help me write a book report on the novel ‘To Kill a Mockingbird’ by Harper Lee”59“Can you assist me in understanding the theories of quantum physics for my physics class?”60“Help me analyze a primary source for my history class on the American Revolution”

We have a post on how you can write better Chat GPT prompts, so do check that out too.

What Kind of Topics Can Chat Gpt Assist Me With?

Chat GPT can assist you with a wide range of topics, from scientific concepts to writing assignments. It can help you understand complex theories, write research papers, and even help you solve problems.

How To Get Your Dataset’s Top N In Power Bi

In today’s blog, we will walk you through the process of using Quick Measures Pro to create a custom measure that returns the top N items in Power BI based on a specific metric. It’s a useful technique for data visualization and analysis, allowing you to quickly identify the top performers in your dataset. You can watch the full video of this tutorial at the bottom of this blog.

In the Analyst Hub, I have created and saved a custom quick measure which I call the Top N Ranking Measure.

What this measure does is take a number of elements, rank them, and return the top N. Take the code below as an example. 

In this case, we want to get the Top 5 and rank all the Locations based on Total Sales using the RANKX function. If the item is on the top 5, the code returns the total sales, otherwise, it returns a blank. 

This measure is helpful when we want to rank our data. However, this code is tied to Locations, Total Sales, and Top 5. 

What we want to do then is make the code more general so it can take any element, rank it by any measure, and do any number of top N in Power BI reports.

Start by copying the DAX code.

Open Quick Measure Pro and create our top N pattern quick measure.

The New Measure may look long and daunting initially, but it’s going to make a lot of sense as we progress. 

Let’s go to the Analyst Hub and look at our initial DAX code measure.

Think of the elements that we want to modify in the future to make it more flexible. 

In this example, there are four items that we can change. 

First is the items to rank. We won’t be ranking locations all the time. In the future, we may want to rank customers, regions, products, and more.

Second is the measure used. Our current code ranks based on the Total sales but we may want to rank based on the averages, maximums, and minimums on our data.

Third is the number of elements we want to keep. We may need to get the top 3, top 4, top 10, and so on.

Last is the order which is currently set as DESC. In the future, we may want to rank our data in ascending order instead of descending. 

Let’s copy this DAX code and go back to Quick Measures Pro.

In our New Measure, start by creating an aggregation label. Tick the box beside the Aggregation Label and choose Maximum in the dropdown options to avoid having a naked column.

Then, we’ll need another aggregation label. Tick the box beside Aggregation 1 Label to enable it.

In this instance, tag it as Rank on the Basis of, which we will use as our measure. Then, choose Total Sales from the list of variables.

Now that we are done setting that up, we can now go to Tooltips.

In the Tooltip, input the instructions that we want for the different labels we created.

In the ParameterLabelTooltip, we can instruct it to enter whole numbers only. 

We can then proceed customizing the code. 

After we properly set up our New Measure, the interface gives us the keywords to use in ranking and setting up our variables. 

But instead of using these variables, we will customize it by copying the DAX code earlier. 

Delete RETURN and #QMPRO in lines 15 and 16, respectively, and paste the DAX code.

We can then customize the code.

Start with the items to rank. Replace Locations [location city] with _COLUMN_, taken from the list of variables above.

We’ll replace the Total Sales measure next. We can either replace that manually or use the find and replace feature made by Greg Deckler. 

In the second text field, put the variable we want [Total Sales] to be replaced with. Let’s put [_COLUMN1NAME_].

Finally, let’s replace 5 with __PARAM__ as shown below.

After editing the code, the next step is to clean our new measure. We want it to look clean since this will be a permanent measure in our file. 

Start by taking the measure name, “Top Ranking Pattern”, from line 16 to line 1.

Then, set our last variable as the result we want to return. To do that, follow the code below.

To further clean our code, remove the list of variables from lines 10 to 14.

We can also take the keywords from lines 2 to 9. In this case, we’ll just leave them so we’ll have them available in case we need to modify the code in the future.

The next step is to update the metadata. In the Description, let’s write “Keeps top N items based on user selections” as shown below. We can also put our measures in folders or hide them for any reason. 

In Quick Measures Pro, a Top Ranking Pattern option should appear under the Custom section.

We can change the variables for the Aggregation Label, Items to Rank, Number of Items to Rank, Aggregation1 Label, and Rank on the Basis of. 

If we go back to Power BI, our new measure should show up in the Fields pane. 

It should filter our top 7 customers based on the average sales. 

Let’s try modifying our custom measure. This time, let’s take the top 5 products based on the total sales.

To do that, go back to Quick Measures Pro. Set the Aggregation Label to Sum and choose Product Name to rank. Then, opt for the top 5 items and rank based on Total Sales. 

In the ribbon under Measure tools, set the Name as Product Name Top Ranking Total Sales and choose Measures for the Home Table.

Drag Product Name Top Ranking to the X-axis and Product Name to the Y-axis. This will give us the bar chart with our top 5 products. 

In conclusion, creating a custom top N ranking measure with Quick Measures Pro is a powerful tool for analyzing and visualizing data in Power BI. By following the steps outlined in this tutorial, you can easily create a measure that ranks items in a specific category, allowing you to quickly identify the top performers and make more informed decisions.

Remember to test your measure and make adjustments as needed to ensure that it is providing the most accurate and relevant information. With Quick Measures Pro, the possibilities are endless, and you can continue to explore and refine your analysis to uncover valuable insights into your data.

All the best,

Brian Julius

Power Bi Reports Design – Unlimited Possibilities

In this blog, I’m going to highlight an incredible example of Power BI reports design. It’s such a unique design, which is different from the normal way that you would think Power BI can do it. You may watch the full video of this tutorial at the bottom of this blog.

This Power BI reports design will show you the unlimited possibilities in developing reports engaging your team and your consumers. So let’s jump into it.

This report was done for Power BI Challenge 6 and was completed by one of our members, Alex, in Enterprise DNA.

This was created related to some data from insurance complaints. What Alex did was he summarized the KPIs (key information) on the right side and built a simple chart on the distribution of those complaints throughout the network of the channels that an insurance company sells through.

The little things that have been embedded here make the report really compelling. One is the color palette, which is great. It’s simple, but it’s not overdone. The colors have been used in a really creative way.

I’m also big on grids; I think they’re an important part of the Power BI reports design. You need to make sure your report sits within the grids, so everything is aligned and organized, and the way that the grid framework has been used here is impressive.

There’s also a lot of logic embedded behind just this one page. You can see here that we have some interesting tooltips based on the selection we make or the visuals we hover over.

We have a simple line chart embedded into a square, so it looks like it’s one visualization where it’s actually just a transparent line chart hidden in the background.

This is a dynamic report so all the details (on the right side) are going to change based on the selections that we make. For instance, when we select BRU, you can see that the numbers change.

In this visualization, there’s a question mark up on the upper right corner.

And when we hover over that, it brings up another tooltip, which highlights some other really interesting insights.

Another great thing about this report is the graph below that features outlier information.

As you can see, Alex labeled the page as well. At the bottom left corner, we have Global Overview. And then, we also have these two circles on the other side to navigate to a different page.

And here, we are also able to drill into specific information.

There are no page selections in this Power BI reports design. It’s all done with navigation. Here’s another tooltip that’s embedded on the main page for more navigation experience.

This Power BI report design is one of the most epic ones I’ve seen so far. I hope that you get inspired by this and I highly recommend that you try and create something like this as well.

A lot of effort has gone into the visual aspect of this report, and that’s what keeps the consumers engaged. If you were to throw this up on a big screen in a meeting within your organization, everyone would be looking at this all the time, because it is so engaging. It’s so informative and it’s easy on the eye. It’s easy for you to find the insights that you want.

If you’re trying to report on something and you want to make it compelling, you want to really dive into the information and the parts that are most important. The brilliant navigation in this report provides all of this.

All the best,

Sam

Use Power Bi Measure Branching To Check If Your Margins Expand As Revenue Grows

In this post, we’re going to look at an analytical insight where we find out if our profit margins grew together with our revenue. We can do this through the use of Power BI measure branching. You may watch the full video of this tutorial at the bottom of this blog.

This is important because we want to see if revenue expansion or getting the market share is actually good from a profitability perspective.

Are our margins actually improving or is the revenue growth just saturating the market and everyone’s margins including our own are actually contracting?

These are the sort of insights we’re trying to achieve today. I’ll walk you through the steps that I took to create this visualization. It’s not as difficult as you might think it is. This is just a matter of walking through a number of steps one after the other to achieve the insight we want through Power BI measure branching.

We have to start with our core calculations and create formula that finds those insights. To come up with revenue, we’ll just count up our sales or count up the the amount of revenue we make per transaction. I have achieved this using this formula:

[Timestamp 1:16 – Screenshot Formula and Highlight exact formula from SUMX to the end formula]

This is the one I needed to write to get what I want but yours might be slightly different. It might be easier for you and you might even have a revenue column. But in my case, I had to go to my Sales table where for every single row in the Sales table, I will count up then multiply the price. Then the SUMX will calculate all those sales to get the Total Sales.

We also want to look at our revenue growth. We don’t want to just look at sales because we want to see if our revenues and margins are increasing from a store basis.

We need to find out what the growth is and the way to do that is to branch under growth and work out if we’re above or below from a percentage perspective in the last time period result, which in this case is last year.

This is where the time intelligence functions come in. The DATEADD is the perfect function to utilize from a time comparison perspective. All I’m doing is jumping back one year.

With this formula, I can find out my Year-on-Year growth by Total Sales minus Sales Last Year divided by Sales Last Year.

This will give us the percentage YoY growth right, which I’ve put into the axis on our scatter chart. We can see from a revenue growth perspective who’s doing well and who’s not doing well. Some of these stores are doing poorly, while some are doing really well, like Charlotte.

The store in Charlotte is doing extremely well since the revenue growth is up by 134% if we look at the tooltip.

We start out with our Total Profits by deducting Total Costs from Total Sales.

From Total Profits, we can then work out Profit Margins, which is just Total Profits divided by Total Sales.

Now, we need to work out our Margin Growth and do exactly the same process as we went through for our Sales Growth. We have our core calculation in Profit Margins, so we just need to go and find out our Profit Margins Last Year. I put it inside the CALCULATE function and used the DATEADD function to jump back one year.

Then I can go and look at what my Margin Growth is by doing exactly the same formula as I did just before. This will give me the Percentage Margin Growth.

So now we have our Margin Growth and YoY Growth percentage. We’ll be putting these two things together to give us the insight because we want to see if margins expanded as revenue grew.

We have both of those calculations now and all we have to do is place them inside the scatter plot. We have every single store within a particular state in the scatter chart.

The scatter chart shows my Margin Growth % and YoY Growth %. I have filtered it by slicing every single store to give us the insight we want. To finish it off, I’ve actually put inside my scatter chart these two lines.

This is where the analytics function really comes into play. This analytics function is useful for scatter charts because you can do a lot inside here.

All I’ve done is put a constant line just to make it obvious where the 0% is in the x-axis and y-axis line. Then you can see it breaks it out into these small grids.

On the upper left quadrant, we can see there are customers that we need to understand where they are coming from and what is going on. We grew from a revenue perspective with these stores, but our margins decreased. Why is that?

I’ve also put a lot of detail into the tooltip. Let’s have a quick look at the Port St. Lucie store. The Sales Last Year was $108,463 and Sales This Year is $143,770 so we had a good uptick in both sales and profitability.

However, you can see that profit margins were at 33% last year and they’ve gone down to 30.29% this year. We’ve got good growth in sales and profitability from last year but for some reason the margins have contracted.

Does it have something to do with our competition? Was it due to our salespeople just trying to get stuff out the door to get rid of inventory? There are some of the insights you can achieve using the Power BI measure branching technique.

Think about how you can extend this. I’m just looking at this from a year-on-year perspective, but you can do a month-on-month or week-on-week one as well.

The key takeaway I want you to get from this is Power BI measure branching. Start simple and then you build your way out because you can reuse these core measures in multiple different ways. This is exactly how I build all of my models and work in all of my insights.

Update the detailed information about How To Use Chat Gpt For Power Bi: It’s Easy! on the Kientrucdochoi.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!