Forum Discussion

ObsidianMagne's avatar
ObsidianMagne
Regular Visitor
2 years ago
Solved

Problem with cumulative line chart

Hi all   I'm trying to create a line chart in order to compare sales data for the same period but for different years. The thing is that I need different lines for each year. I've read many posts a...
Need Help
ObsidianMagne's avatar
ObsidianMagne
Regular Visitor
2 years ago

Hi ashish

 

Below is a sample of the data I use. Right now I build the visual in excel but I need to change it to power bi.

The visual shoul look something like this for each distribution channel (I will use a slicer for that), at the moment it is a weekly report

 

 

 Thanks a lot for the help

 

channelDATEsum
MULTIAGENTS2/1/202468,40
MULTIAGENTS2/1/202422,8
MULTIAGENTS2/1/202468,4
AGENTS2/1/2024246,7986
AGENTS3/1/2024456
AGENTS3/1/202411,894
AGENTS4/1/2024204,9948
AGENTS9/1/2024205,029
BROKERS13/1/202434,96
BROKERS26/1/2024498,427
AGENTS26/1/2024333,431
AGENTS26/1/202411,894
AGENTS26/1/2024197,4214
AGENTS26/1/202476,304
AGENTS26/1/202476,304
AGENTS29/1/2024120,3498
AGENTS29/1/2024107,5666
AGENTS29/1/202422,8
BANCASSURANCE7/2/202445,41
BANCASSURANCE7/2/202445,4138
BANCASSURANCE7/2/202445,4138
BANCASSURANCE7/2/202450,9314
BANCASSURANCE7/2/202445,4138
BANCASSURANCE7/2/202450,9314
BANCASSURANCE8/2/202450,9314
MULTIAGENTS13/2/202422,8
BROKERS1/3/202414,44
BROKERS1/3/2024439,4966
BROKERS14/3/202474,8182
AGENTS14/3/202414,44
AGENTS14/3/202414,44
AGENTS14/3/20241900
AGENTS14/3/2024228,5016
AGENTS15/3/2024456
AGENTS19/3/202422,8
AGENTS19/3/202414,44
MULTIAGENTS20/3/2024320,682
AGENTS20/3/2024303,9658
AGENTS21/3/202495,7258
AGENTS22/3/2024264,5446
MULTIAGENTS23/3/2024180,9674
AGENTS26/3/2024265,1146
AGENTS26/3/2024177,7792
MULTIAGENTS12/5/2023430,3386
BROKERS23/1/2023532,6916
BROKERS31/3/2023186,27
MULTIAGENTS28/6/2023476,8088
MULTIAGENTS28/6/2023611,8988
MULTIAGENTS30/10/2023701,9056
MULTIAGENTS16/10/2023321,4572
MULTIAGENTS28/3/2023395,6142
MULTIAGENTS17/2/2023232,7462
MULTIAGENTS10/7/2023395,6104
MULTIAGENTS28/11/2023695,2138
MULTIAGENTS20/6/2023161,79
MULTIAGENTS3/1/2023510,7504
MULTIAGENTS21/10/202334,96
MULTIAGENTS21/10/202334,96
MULTIAGENTS21/10/202334,96
BROKERS2/2/20231923,716
BROKERS9/1/2023699,52
BROKERS8/3/2023731,25
BROKERS9/5/2023238,1536
BROKERS13/7/2023731,23
BROKERS30/6/202365,4664
AGENTS21/7/2023153,2008
MULTIAGENTS21/7/2023153,1666
MULTIAGENTS8/9/2023230,4852
AGENTS28/4/2023132,0462
AGENTS19/9/2023341,0196
AGENTS4/8/2023205,2456
AGENTS25/8/2023379,9848
AGENTS15/2/2023261,6604
AGENTS20/2/202371,6034
AGENTS17/2/2023464,2498
AGENTS15/2/2023130,8758
AGENTS16/1/2023168,0968
AGENTS26/7/202371,6034
AGENTS1/12/2023306,0672
AGENTS20/12/202376,304
AGENTS3/4/2023134,4744
AGENTS21/3/2023213,104
AGENTS16/3/2023119,662
AGENTS28/3/2023259,7642
AGENTS16/3/2023123,3062
AGENTS6/7/2023193,6594
AGENTS14/4/2023309,7266
AGENTS25/12/2023456
AGENTS21/3/2023143,07
AGENTS29/3/2023719,2108
AGENTS27/6/20231264,192
AGENTS27/9/2023147,4248
AGENTS14/9/2023201,685
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

This is the best i can do.  PBI file attached.

Hope this helps.

 

  • ObsidianMagne's avatar
    ObsidianMagne
    Regular Visitor
    2 years ago

    Not really but thanks anyway Ashish

    Regards