Forum Discussion
Which Visual to use?
I have data for feedback with count for YES and NO. I have these values by month on x-axis with line graph Legend: Yes; No. Now I would like to include year. Is there a visual in BI which can incorporate all these values?
~Nita
You can just drop the Year field just below Month on x axis of line chart. Then you can use the drill down to get the value of Year wise data.
Hi Anonymous
Try using a clustered column chart. Use Year as the Legend and put your Feedback under Axis (so axis will now have Month and Feedback). Then, expand it down the hierarchy (the split arrow icon). You can choose to show Feedback first or Months first, depending on how you want to present your data. Generally, I will put Feedback at the top, so your first view will be Feedback by year, then when you expand it down, you will see Feedback by Month by Year.
2 Replies
Tahreem24Super User
You can just drop the Year field just below Month on x axis of line chart. Then you can use the drill down to get the value of Year wise data.
- darentengmfs
Post Prodigy
Hi Anonymous
Try using a clustered column chart. Use Year as the Legend and put your Feedback under Axis (so axis will now have Month and Feedback). Then, expand it down the hierarchy (the split arrow icon). You can choose to show Feedback first or Months first, depending on how you want to present your data. Generally, I will put Feedback at the top, so your first view will be Feedback by year, then when you expand it down, you will see Feedback by Month by Year.