Create custom data label showing weekly change

[Majad_Chowdhury]

Hi All,

I have a dataset that contains information on what sales stage each customer is each week.

Week	Customer	Stage
1	Grapefruit	Lead
2	Grapefruit	Negotiation
3	Grapefruit	Contract
1	Bell	Negotiation
2	Bell	Negotiation
3	Bell	Completed
etc	etc	etc

'So imagine something like this:

I have a clustered column visual which is always filtered to a week. So lets say its only showing week 4 data.

The X axis has Sales Stages.

e.g.

0% - Lead

20% - Approach

40% - Negotiation

60% - Agreement

80% - Contract

100% - Completed

The Y axis has the number of customers in each stage (Count of Customer). I want to have a data label that shows the week on week change. So in this instance we have Week 4 selected, I would like the data label to show the growth/reduction in amounts in each sales stage from week 3. Ala the pic below.

Hope ive made the problem clear enough to solve, let me know if you need more information

[Daniel29195]

@Majad_Chowdhury 

so ,

the visual is always filtered to 1 week .

+  

the visual oin the x axiss shows the stages.

you want per eachs tage, the week over week change as custom data label .

one more thing,

does the column week  have from 1 -- 53 weeks,per year or does it just continue nonstop ,?  45, 55, 56  ? 

i will create the measure assuming that your week column contains data from week1 to week53 per each year

sample data : 

count ofcustomers for week2 =  3 

count of customers for prev week  = 1 

w over w = (3 - 1) / 1  = 2/1 = 200%

ouptut : 

measure : 

Measure 5 = 

var prev_week = 
CALCULATE(
    COUNT(week_over_week[customer]),
    OFFSET(
        -1,
        CALCULATETABLE(
            SUMMARIZE(
                week_over_week,
                week_over_week[week]
            ),
            REMOVEFILTERS(week_over_week[week])
        ),
        ORDERBY(week_over_week[week] , ASC)
    )
) 


return  (COUNT(week_over_week[customer]) - prev_week ) / prev_week

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠