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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
halldon
Regular Visitor

Time series with Numeric Values and Text Values

Hi, 

 

I'm looking to see if there exists any visuals that allow you to display both the numeric value of a time series, and an attached note. The note would be in the same row as the numeric value.

 

Background: I work in a manufacturing enviroment. I have moved over to BI for almost everything I do, except for a time series that I have in excel. This excel file has numerous tabs, each being a piece of equipment in our factory. Each time series has date on the x-axis, and the downtime on the y-axis. These time series are fed by a query to a sharepoint list. When I refresh the query, I click on the data labels, and put notes in reguarding what happened from both the production and maintence side of things. See the picture below.

 

halldon_0-1691417956176.png

 

What I would like to do, is find a BI solution to this. For example, have one time series that has a filter for equipment, select that piece of equipment, then it generates these time series. I figure I can just add a new column called "Time Series Annotation" to the sharepoint list, and so that text can be displayed underneath the minutes. I just have no clue how to do this or if there exists visuals that can do this.

 

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors