Forum Discussion

Varishtha's avatar
Varishtha
Icon for Helper I rankHelper I
2 years ago
Solved

Stagger Chat in Power BI

I am trying to make a stagger chart for actual sales generated and forecasted sales for next 4 months. Below is what it looks like in excel:   I tried to put "sales" measure in the matri...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Varishtha ,

    If you want to use 20 as your forecast sales value for the next month, please take a look at this test:

    My Model View:

    Calender = ADDCOLUMNS(CALENDAR(DATE(2024,1,1),DATE(2024,12,31)),"Start of Month",DATE(2024,MONTH([Date]),1),"_Month",MONTH([Date]))

    I created another new table:

    Table 2 = VALUES('Calender'[Start of Month])

    My Report View and Measure value:

    Measure = IF(

     MONTH( MAX( 'Calender'[Start of Month] ) )=MAX('Calender'[_Month] ) ,

    MAX('Calender'[_Month]), 0)

    Measure 3 = IF( MONTH( MAX('Calender'[Start of Month]))  = MONTH( MAX('Table 2'[Start of Month]) ) ,MONTH( MAX('Calender'[Start of Month])),  IF( MONTH( MAX('Calender'[Start of Month])) +1 = MONTH( MAX('Table 2'[Start of Month]) ) , 20 , BLANK()))

    Best Regards,

    Sunshine Gu 

Varishtha's avatar
Varishtha
Icon for Helper I rankHelper I
2 years ago

Hello Anonymous ,
Thanks a lot, I did figure this out. I want to add forecast sales for next 4 months as well (like in the excel snap below).

So, I modified the measure accordingly, but I am getting empty values in the table(as visble in snap below):
Measure:

exp v_BKsales1 = IF(
                   (MONTH(MAX(Calender[Start of Month]))+1)=MONTH(MAX(Calender[_Start_of_month])),
                   20,
                   IF( MONTH(MAX(Calender[Start of Month]))=MONTH(MAX(Calender[_Start_of_month])),
                   [UMSATZ_BK],
                     0)
)

P.S., I have mentioned "20" , instead of the sales measure, just for simplicity sake.

The number 20 should have populated in the blocks I have marked in snap above, but no values are coming.

It would be really helpful if you could help me with this.

Regards,
Varishtha N