Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 incorpo...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    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's avatar
    darentengmfs
    5 years ago

    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.

     

     

     

darentengmfs's avatar
darentengmfs
Post Prodigy
5 years ago

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.