Need help adding a percent growth/decline line between quarters

[RichOB]

Hi, I have a line and clustered graph and want to add the percent growth/decline from one quarter to the next (not the percent line shown as the total). It currently looks like this and I want the pink line if possible please. X Axis is Fiscal_Q from the calendar table and Y axis is the count of CustomerID from Sheet 1.

I have 2 sheets, one with customer data and the other is a calendar with fiscal quarters. This is how my Fiscal date table is set up: 

Sample of how my customer data is structured:

CustomerID	Date
CST1	01/04/2023
CST2	01/04/2023
CST3	01/04/2023
CST4	01/07/2023
CST5	01/07/2023

Unfortunately, the previous post didn't solve the question for me, apologies for the repost. Thanks in advance!

[Irwan · Accepted solution]

hello @RichOB 

please check if this accomodate your need.

1. create a new measure for customer ID count.

Count = COUNT('Customer'[CustomerID])

2. create a new measure for percent

Percent = 
var _Quarter = SELECTEDVALUE('Date'[Fiscal_Q])
var _Current = CALCULATE(COUNT('Customer'[CustomerID]),'Date'[Fiscal_Q]=_Quarter)
var _Prev = CALCULATE(COUNT('Customer'[CustomerID]),PREVIOUSQUARTER('Date'[Date]))
Return
DIVIDE(
    _Prev-_Current,
    _Prev
)

3. create line and cluster column chart and put your count measure in column y-axis and percent measure in line y-axis.

note: dont forget to create a relationship between date tabel and your table

Hope this will help.

Thank you.