Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aiyosap
Helper II
Helper II

How to display the monthly percentage changes ratio in bar chart

Hi,

 

I have a Line and Stack column barchart showing month to month a request order below. 

I would like to show the percentage changes (monthly percentage up and down) for total request in each month below instead of showing the total order request.

 

F1.JPG

 

 

 

 

 

 

 

The setup of this visual is as following...

F2.JPG

 

 

 

 

 

 

 

The measure (i.e. Request Volume Simple) is written as...

Request volume simple = CALCULATE(
          DISTINCTCOUNT(All_cases_dataset[Case ID]),
          'All_cases_dataset'[SimpleComplex Flag] = "Simple")
 
Hope you can help in the measure DAX.
I went through some previous forum but it does not help in my case.
 
Regards,
Aiyo
1 ACCEPTED SOLUTION
amirabedhiafi
Impactful Individual
Impactful Individual

If I will take the first scenario which is month on month growth: 

You have : 

Request volume simple = CALCULATE(
          DISTINCTCOUNT(All_cases_dataset[Case ID]),
          'All_cases_dataset'[SimpleComplex Flag] = "Simple")

You need to create another measure like below : 

Prev Month  = CALCULATE( [Request volume simple], DATEADD(DimDate[Date], -1, Month) )

and then :

Growth % = DIVIDE ( [Request volume simple - [Prev Month ], [Prev Month ])

 

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

View solution in original post

4 REPLIES 4
aiyosap
Helper II
Helper II

Hi Amira,

my month to month means compare current month to the previous month of the same year, and that would also means compare Jan 2022 to Dec 2021.

 

Thanks.

Aiyo

Hi,

Assuming you have a Calendar Table and Year-Month has been dragged from the Calendar Table to the row well of the matrix visual, write these measures:

Request volume simple in previous month = calculate([Request volume simple],previousmonth('Calendar'[date]))

Growth in request volume = divide(([Request volume simple]-[Request volume simple in previous month]),[Request volume simple in previous month])

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amirabedhiafi
Impactful Individual
Impactful Individual

If I will take the first scenario which is month on month growth: 

You have : 

Request volume simple = CALCULATE(
          DISTINCTCOUNT(All_cases_dataset[Case ID]),
          'All_cases_dataset'[SimpleComplex Flag] = "Simple")

You need to create another measure like below : 

Prev Month  = CALCULATE( [Request volume simple], DATEADD(DimDate[Date], -1, Month) )

and then :

Growth % = DIVIDE ( [Request volume simple - [Prev Month ], [Prev Month ])

 

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
amirabedhiafi
Impactful Individual
Impactful Individual

When you say month to month is it :

- you compare the current month by its previous one for the same year?

- or you compare the current month and the same one for last year ?

Can you please provide an example ?

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.