Power Bi - Graph Axis

[Bankesy]

Good morning,

 

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

[Marci]

You use a matrix visual and drag multiple fields to the axis, then enable drill down at top and drill down to all levels. Or add measures that do the count of types as tooltips...

Many diff ways to do it depending on your model / table and how the data it contains is structured.

 

Have you created a Dimension table of all the different (unique) doughnut types available in the column (duplicate your query, remove excess columns, remove duplicates to give you a top level list), and related it to that column? If so, then you'd drag the "name" col from that Dimension table onto the matrix (for instance).

 

Screenshots of how you currently have the visual setup showing available fields of your table etc would be helpful.

Most folks' initial problems getting to grips with PowerBI can be solved by wandering thru Power BI fundamentals training at MS Learn using their sample data etc... https://learn.microsoft.com/en-us/training/paths/model-data-power-bi/

Edited November 1, 2024 by Marci

[Bankesy]

@Marci

 

Thanks for the reply, I joined a Power Bi forum and got the answer there which was similar to what you're saying anyway. Essentially I was putting the wrong things on the wrong axis and not labeling the legend.