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 diff...
Need Help
SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident 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