cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## How to calculate sales growth monthly and quarterly and added the same in drill down?

Hi

I am creating a chart to visualize the comparison between the market and products with showing sales and sales growth for monthly and quarterly. I need to add these feature in the chart as a drill-down.

My data has two tables one is a date table and another one is raw data

I have created a clustered bar graph using the country column as a market and sales. Product in the legend for the comparison. Now I need to calculate sales growth for monthly and quarterly and show it as a line in the bar graph. The idea is to show both sales vs sales growth in each market against different products. This has to be in drill-down features for both monthly and quarterly.

Could you please advise how to calculate the sales growth and also am I using the right chart?

1 ACCEPTED SOLUTION
Community Support

Hi @Jason2500 ,

If caluculated the sales growth for each product, the line number must be the same the number of products.

Create a measure like this to calculate the percentage:

``````Percentage =
VAR _current =
SUM ( Sales[Sales] )
VAR _previous =
CALCULATE ( SUM ( Sales[Sales] ), DATEADD ( 'Calendar'[Date], -1, MONTH ) )
RETURN
DIVIDE ( _current - _previous, _previous, BLANK () )
``````

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

Hi @Jason2500 ,

If caluculated the sales growth for each product, the line number must be the same the number of products.

Create a measure like this to calculate the percentage:

``````Percentage =
VAR _current =
SUM ( Sales[Sales] )
VAR _previous =
CALCULATE ( SUM ( Sales[Sales] ), DATEADD ( 'Calendar'[Date], -1, MONTH ) )
RETURN
DIVIDE ( _current - _previous, _previous, BLANK () )
``````

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User

@Jason2500 , Line in clustered column chart will not split by legend. (Product)

Check for any custom visual for that

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

You have to keep both line or use measure slicer to switch lines

For QOQ and MOM

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors