Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hdbrooks
New Member

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.

 

hdbrooks_2-1652470660429.png

 

Any support would be greatly appreciated. 

 

1 REPLY 1
v-zhangti
Community Support
Community 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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.