Column Chart does not display when combining Year and Name

[s15]

I have a dataset that contains Year and Actor. Actor column has approximately 8,000 rows and Year column has 30 rows.

I've tried to show a column chart but the chart does not display.

Is that a limit based on my expectation? If it is, I wish another option that I need to sum all actors by years then display the chart. What is the keyword you'd recommend me to study about?

Thank you.

[s15 · Accepted solution]

I think I can find a way to count the total of actors then show by year by using Measure (under Value).

[v-shex-msft · Accepted solution]

Hi @s15,

>>I've tried to show a column chart but the chart does not display.

Column chart not support show text in value field, you can right click on that column and choose a summary function to convert it to value.

Regards,

Xiaoxin Sheng

[s15 · Accepted solution]

I think I can find a way to count the total of actors then show by year by using Measure (under Value).