The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all
This seems like a simple thing to do but I can't figure this out....
I have a simple table that has Anomaly values against years
In Excel I can get a Line chart to plot these values
But the best I can seem to do in PBI is a scatter chart
I can never get the column charts (clustered or stacked) to plot a simple x vs y plot.
Feel like I'm missing a trick here. Have formatted the years as whole numbers and the only thing I can think of is that it's direct number plotting rather than aggregation / summing etc for the Anomaly values. Can't really get the scatter chart to behave as I'd like it either.
All thoughts welcomed!
Cheers
Keith
Solved! Go to Solution.
So the take away from this is graphs only allow measures to be used on the y axis!
Hi both
Thanks for your input! Had figured the line chart was the correct chart but couldn't get the Anomoly value to be accepted onto the Y Axis (should have mentioned this!). After messing about and reading around, changing the way the data was being bought in, turns out using
SumAnom = SUM( tbl_Anomoly[Anomaly] )
tbl_Anomoly[Anomaly]
Good start to the day! Have liked both solutions but not accepted either as the solution, hope this is ok and thanks for your input!
Have an ace day both!
Cheers
Keith
So the take away from this is graphs only allow measures to be used on the y axis!
Hey Keith! Have you used the line chart in Power BI? It should format for you even if your years are aggregated
Hi! If you create a line chart with the x-axis set to categorical instead of continuous, and ensure that it is sorted ascending by year you can get the look you are going for:
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
90 | |
83 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |