cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rosie64
Regular Visitor

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

Rosie64_0-1675117063295.png

 

 

1 REPLY 1
SivaMani
Resident Rockstar
Resident Rockstar

@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

SivaMani_0-1675119283945.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors