Forum Discussion

dv1407's avatar
dv1407
Regular Visitor
3 years ago

Power BI chart with target line

Hello, I would like to make a diagram showing the actual and the target line (green), as shown in the photo. How do I get that in PowerBi? The image is from Excel.

 

I tied a sharepoint list in which it counts the lines with the status "Done" and these are then provided with a month. Now the target line must count all rows and distribute them over 12 months.

 

Need Help

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello dv1407 ,

     

    In Power BI Desktop create a line visual and create a target line with the help of Analytics tab and it will help you to create a target line. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

  • dv1407's avatar
    dv1407
    Regular Visitor
    3 years ago

    Hello, please help me a little bit more.

    What would be the right choice in Analytics to get the line? Here is the calculation for each month. I'm still missing the filter for the "Done" status here, how do I get that into the formula?

     

    Laufende Summe von Anzahl von field_8 in Monat =
    CALCULATE(
    COUNTA('tbl_turnus_aufträge'[field_8]),
    FILTER(
    CALCULATETABLE(
    SUMMARIZE(
    'tbl_turnus_aufträge',
    'tbl_turnus_aufträge'[Modified].[MonthNo],
    'tbl_turnus_aufträge'[Modified].[Monat]
    ),
    ALLSELECTED('tbl_turnus_aufträge')
    ),
    ISONORAFTER(
    'tbl_turnus_aufträge'[Modified].[MonthNo], MAX('tbl_turnus_aufträge'[Modified].[MonthNo]), DESC,
    'tbl_turnus_aufträge'[Modified].[Monat], MAX('tbl_turnus_aufträge'[Modified].[Monat]), DESC
    )
    )
    )