Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |