Forum Discussion
Power Bi - Excel Spreadsheet Cell Content
Good morning,
As a new user I am hoping somebody with some Power Bi knowledge can tell me what I might be doing wrong here, the following example uses a made-up scenario but mirrors what I'm trying to achieve with some real alternative data:
I've imported a spreadsheet that was populated via a Microsoft form into PowerBi, one column has dates and one has the answers from the form when people selected either a strawberry or chocolate doughnut.
What PowerBi shows me on one axis of the graph it creates is time scales according to the date column (years, months, days), perfect, exactly what I want.
On the other axis it shows the 'count' of the strawberry\chocolate doughnut column...so if 20 people selected either doughnut in October the graph shows 20 for October.
What I can't work out is how to get the graph to show me that in October, 15 people selected chocolate doughnut and 5 selected strawberry.
It's like PowerBi is only capable of counting how many entries there are for a column but not the content of the cells in that column.
Hope that kind of makes sense if anybody has any suggestions.
Thanks
Hi Bankesy26-_
Sounds like you would need to specify the Donut column as the Legend in your visual.
It should look something like this.
Let me know if it solves your issue.Hi,
I am not sure how your data looks like but if they are in the following formatthen you can use a stacked column or stacked area chart (depending on the purpose) where on the X-axis you add the dates, on the Y-axis you add the distinct count of employees and on the legend you add your selection. This way you will get the following result
4 Replies
Hi,
I am not sure how your data looks like but if they are in the following formatthen you can use a stacked column or stacked area chart (depending on the purpose) where on the X-axis you add the dates, on the Y-axis you add the distinct count of employees and on the legend you add your selection. This way you will get the following result
Hi Bankesy26-_
Sounds like you would need to specify the Donut column as the Legend in your visual.
It should look something like this.
Let me know if it solves your issue.Thank you all for your responses, I'm sure one of them will help me. If we translate the doughnut example into my real data it looks like this:
And I am trying to measure how many people select 'Report an incident' or 'Log a service request' over whatever time period.
I will give all of your suggestions a go.Thank you
Hi Bankesy26-_
You can add an item into the Details to split the data in your chart.
So the count goes in values.
The original column goes in Details also.
