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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nmcclary
Helper II
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

 

nmcclary_0-1622134578423.png

 

1 ACCEPTED SOLUTION

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.

View solution in original post

2 REPLIES 2
nmcclary
Helper II
Helper II

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

 

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.