Which Visual to use?

[Anonymous]

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

[Tahreem24 · Accepted solution]

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 · Accepted solution]

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.

[Tahreem24 · Accepted solution]

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.