Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
The setup of this visual is as following...
The measure (i.e. Request Volume Simple) is written as...
Solved! Go to Solution.
If I will take the first scenario which is month on month growth:
You have :
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 ])
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.
If I will take the first scenario which is month on month growth:
You have :
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 ])
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 ?
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |