cancel
Showing results 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

Helper II

## Dynamic Grid for Dashboard

Hey everyone,

I have received the request in the screenshot below for an organization wide dashboard. I know how I will build most of it but what I can't figure out how to approach is the grid on the right. In this example, there are 24 metrics coming from 10-15 different sources. Each of these are different calculations. I can easily make a grid that has the values but what I can't figure out is how to get the target, score, and weight to transfer over. The target, score, and weight will be housed in another static table. What's the best way to approach this?

Also, the end user would like the feature where you highlight a metric title and the box in the lower middle will populate with the information listed. I believe I can figure this out but if anyone has quick tips there, that is appreciate as well.

Thank you,

Nick

1 ACCEPTED SOLUTION
Helper II

After looking at this a bit, I was able to figure out. Solution is super easy, though I don't know how optimal it will be as data sets get larger. Posting this for reference for anyone in the future.

On the left hand side, the metric name comes from the static table along with the goal and weight. The score is then put in using an: if(values(Metrictext) = "MetricName1", [MetricScore1],
if(values(Metrictext) = "MetricName2", [MetricScore2],... and so on and so on. I'll do the same calculation for the "Status" option. We'll see how it performs with 30 different metrics but may be the only solution.

2 REPLIES 2
Helper II

Any help available on this topic or other recommendations for how to display is greatly appreciated.

Helper II

After looking at this a bit, I was able to figure out. Solution is super easy, though I don't know how optimal it will be as data sets get larger. Posting this for reference for anyone in the future.

On the left hand side, the metric name comes from the static table along with the goal and weight. The score is then put in using an: if(values(Metrictext) = "MetricName1", [MetricScore1],
if(values(Metrictext) = "MetricName2", [MetricScore2],... and so on and so on. I'll do the same calculation for the "Status" option. We'll see how it performs with 30 different metrics but may be the only solution.