Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |