Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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?
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Great, I will have a look at it.
Thank you very much for your help.
Regads
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
@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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |