Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Lean Visual Management Board in Power BI

I am looking to recreate visual management boards that we use on our plant floor to track productivity, quality, safety, and cost by day each month.  I have all the data I need, I just can't seem to figure out a way to recreate the visuals in power bi.  

 

My goal is to get the end result to have some type of monthly performance, broken down to performance by day for each one of these metrics to look like the visuals below.

 

  

 

 

I have tried to create individual cards by day with the measure below and align them in the shape of each letter.

Performance Day 25 = calculate(average('Daily Production Metrics Analytics'[Molding Performance]),Filter('Daily Production Metrics Analytics','Daily Production Metrics Analytics'[Day]=25)). 
 
This gives me daily results for performance like I am looking for, but the only way I can conditionally format cards is colored text, I can't conditionally format the entire card background based on the measure. 
 
I've also tried to think of a way to create a donut chart with a legend by day, but I can't conditionally format the legend based on the results for performance.  
 
Any ideas for how to recreate these visuals in Power BI would be greatly appreciated.
 
Thanks in advance,
Zach
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I have also tried a measure using a Unichar 9899 or 11035 to get a symbol inside a card, but I can't figure out how to get the metrics tied to this character so they can conditionally format based on the monthly results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Did you ever figure out how to do this Zach? Just use measures?