Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Q1 | Q2 | Q3 | Q4 | |
Document Revised | 13 | 0 | 14 | 0 |
Approved | 0 | 35 | 27 | 50 |
Remaining Documents | 42 | 20 | 14 | 5 |
Target | 13 | 27 | 41 | 55 |
@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
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |