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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

How would I create a Trend Analysis visualization (line graph) using text of employee Morale



How would I go about creating a trend analysis visualization (line graph) to track employee morale / employee workload with Months / Years.


Currently, this is what I have:



This graph is only showing the months (X-axis) and the count for each month (Y-axis). I would like to visuialize the feelings of an employees morale such as: Good, Fantastic, OK.


Any help would be appreciated.


Frequent Visitor

@Omar_204 I think this broken visual has to do with either your dataset does not contain the right information or the relationships of the tables that you have defined is inaccurate. I will show you one quick example here.

I have created 3 simple tables: Date, Morale, & Fact. My Fact table contains information that can relate to Date & Morale tables where each period (Month) has Morale evaluation results for each employee (I am assuming to have 8 employees). The line chart takes Month as the Y-axis, Count of Employee ID as the X-axis, and Employee Morale as the legend. The visual from these tables are shown as below. (Note that this example is not the best but should help to give you some ideas to work on yours) Thanks.



Hi @JChai,


When I went to create a line graph, it's showing only Axis NOT X-Axis or Y-Axis. How did you get both of these fields to appear.


See below.




Frequent Visitor

Hello @Omar_204,


I am not certain how your data looks like but I think adding the MORALE column as legend for the line chart should work fine for your objective.




Hi @JChai ,


I added the MORALE column to the legend and it's only showing up as dots/points. I want this trend graph to show as a line graph. 


The Axis is the Months, and the values is set to the count of morale.


Any ideas ?


Thank you.


Why your Y Axis has only to values, 1 and 2 ? 

Shouldn't be Y-Axis Sum instead of Count?

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors