Forum Discussion
Helper INeed help with stacked bar chart visual
jdbuchanan71 I was able to make this work by creating multiple measures and then plotting them on the bar chart. Thanks for all your help!
Super UserIf I understand correctly, you want the count of no 1-on-1 to include employees that are not in your meeting table, since they have not had a meeting.
I think you are going to need a higher level table to sit over your meeting table. The higher level table would be and employee table and it would include their manager tagging. That way you have something to count against : employees from the employee table that don't have a 1-on-1 meeting in the meeting table.
It is difficult to help with more complex modeling questions without a sample file to work on.
Helper Ijdbuchanan71 the users that have not had 1on1 are in my table but I realized that the calculated status column that i have created is throwing things off.
I tried creating the below measure but it doesn't allow me to add this as a field under the 'legend' section in the bar graph
Status_N =
SWITCH (
TRUE,
[Count of 1on1s] > 0
, "Has had a 1on1",
[Count of 1on1s with rating] > 0, "Has had a 1on1 with rating",
"Has not had a 1on1"
)
If there was a way to create this status as a measure that can be used on the graph that would solve it. I'm checking if I'm able to share the pbix and will get back to you. Thank you so much for your help!
- sunit1190
jdbuchanan71 any thoughts on how I can create a measure that I can plot on the chart?