Forum Discussion
Creating scorecard concept
Hello
I am still pretty new to power BI and I am struggling with the concepts I need to integerate into a power BI report I would like to create based off a standard excel scorecard file Ive been using for a while. I am using a list to capture the data now. I initially started some reserach into the scorecard function in power BI, but it didnt seem like it would provide the data in a view like show below.
Concept 1: I know I would like a single line graph (plan vs actual) as shown below. I suspect, the best way to have my graph only show months betwen April to April is the filtering option, but I dont quite understand how to limit a graph between two specific dates. If you could suggest filtering topic, would be appreciated.
Concept 2: I would like to create what i suspect to be tables to capture an average of the quarters (different then the standard US quarters), but i would normally do this with a row function in excel which isnt how my lists work. It seems like i would need to create a calculation between two specific dates, but do i do this in the data query section or should i have my list do it? Also seems like it would just create 1 collumn that only had one data entry into it.
Concept 3: Is their anyway to have symbols populate based off some scale? I would have to reference a calculated table as in concept 2.
Any support would be greatly appreciated.
1 Reply
- v-zhangtiCommunity Support
Hi, hdbrooks
You can refer to the following link, hope it can help you.
https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-scorecard-visual
https://docs.microsoft.com/power-bi/create-reports/service-goals-create
https://devscope.net/2020/05/12/powerbi-scorecards-101/
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.