count of records per year

[lagarto]

Hi there, I'm very new to Power Bi and I would like to display a count of records ( incident)  per year from the SharePoint list.

The list is very simple and consists of two columns - Incident and Date. I've tried a few things and nothing works as expected. Is anyone able to help? Cheers 

[lagarto]

@Samarth_18 

Thank you very much, I'm getting there now.

@ERD Thank you very much for your suggestion

Any chance I can refresh the data dashboard monthly? 

[Samarth_18]

Hi @lagarto 

Good to hear it helped you. Kindly accept my answer as solution to help other.

For refreshing your data monthly you need to setup schedule refresh in Power BI Service. You can refer below article to setup your schedule refresh.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh 

Thanks,

Samarth

[lagarto]

Great, I will have a look at it.

Thank you very much for your help.

Regads

[Samarth_18 · Accepted solution]

Hi @lagarto 

Could you please share some sample data with expected output. It would help us to provide more specific answer.

In the meantime you can try to add  Year from date column hierarchy and take a count of your incident column directly

Date hierarrchy:-

Count of incident:-

final output would be:-

Thanks,

Samarth

[ERD]

@lagarto ,

I'd suggest you to create a Date table, connect it to your data table (taken from SP list). Then you can use Year column from the Date table in your visual along with a measure. It would be something like

Measure = COUNT ( T[Incident] )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.