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.
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.
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.
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |