cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors