Forum Discussion

hdbrooks's avatar
hdbrooks
New Member
4 years ago

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