Creating scorecard concept

[hdbrooks]

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. 

[v-zhangti]

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.