Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MSTREE
New Member

Trying to visualize one column of weather data over one year for 11 locations

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?Power BI.JPG

2 REPLIES 2
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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. 

 

MSTREE_0-1687357063157.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.