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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors