Power Bi - Excel Spreadsheet Cell Content

[Bankesy26-_]

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

[dk_dk · Accepted solution]

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.

[Bankesy26-_]

@dk_dk @FotFly @SamWiseOwl 

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

[FotFly · Accepted solution]

Hi,

I am not sure how your data looks like but if they are in the following format

then 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

[SamWiseOwl]

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.

[dk_dk · Accepted solution]

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.