Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am looking for the best way to visualize the daily temperature from 11 locations over one year. When I move the Daily Temp to Yxis it changes it to "Count of Daily Temp" and does not show a temp range. How would I get Power BI to display 11 lines for each location of the daily temp over a year?
Hi @MSTREE
Your temp data is text, not a number. That's why you are getting COUNT as the aggregate on the y-axis.
Change the column to a numeric and it should work.
regards
Phil
Proud to be a Super User!
Phil Thank You for your reply but I look at the Temp data and it is formatted as a whole number. I am not sure what I am missing.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |