Forum Discussion

Rosie64's avatar
Rosie64
Regular Visitor
3 years ago

convert simple Excel chart into Power BI

Hi,

I'm trying to recreate an Excel Table in Power Bi - never thought it would seem so complex to create something so simple - maybe its just because I am a novice.  Anyway, trying to get Three different stages for documents monitored over four quarters of the year - with trendline for target.  Simple right?  Not for me - here is the chart in Excel and the data - please tell me what I am doing wrong - I get the chart created etc but maybe my data points in the imported Excel are wrong?  no idea. Thank you in advance!

 Q1Q2Q3Q4
Document Revised130140
Approved0352750
Remaining Documents4220145
Target13274155

 

 

Need Help

1 Reply

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    3 years ago

    Rosie64, Yes, it is doable.

     

    You may need a measure for Target,

    Target = CALCULATE(
     SUM('Table'[Value]),
     'Table'[Type] = "Target"
)

     

    Add the category to the column legend property and exclude Target at the visual level filter, add value column to column y-axis and the target measure to Line y-axis