Hello, I have a SQL table populated with scores 0-5 at different places in time. Please note I am using Direct Query in this file so I cannot create any new tables.
I need to create a line chart for the average of scores at each point in time:
x-axis is the points in time (current_score, 6_months_ago, 12_months_ago, etc.)
y-axis is the average score (first dot will be average of current_score = ((3+0+2)/3).
So I will have 5 dots across the length of the visual with lines connecting those dots.I do have blanks (not nulls) in the dataset that need to be trimmed.
Thanks for any help!
Go to Solution.
Hi @sotoc Open edit queries,Click on "CustID" column, then select "Transform->Unpivot columns->Unpivot other columns",
Create a column
Column = IF([Value]="blank","0",[Value])
Then change its data type to "whole number"
Then Create a measure
Measure 2 = CALCULATE(AVERAGE('Sheet1$'[Column]),ALLEXCEPT('Sheet1$','Sheet1$'[Attribute]))
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!