Advice on visual management board

[NZCraig]

Hi all,

Struggling to thinking of a succint way to present information in a format that I have been requested to create. I have data from a number of tables in my model that our team would like displayed in a Lean Manufacturing type visual management board, with a 12 week trend, over multiple sites and measures/KPIs. The only ways I can think of getting it to work is to use individual tables for each row and place them to give the illusion of a single table, or to use indivdual cards to show each value. Would it be better to try and creat a table in Power Query to do the work or am I on the right track already? I assume if I do it in DAX, I'm going to be creating a lot of measures! An example table is shown below. 
Any advice would be greatly appreciated.

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Week 12

Site 1

Measure 1

Measure 2

Measure 3

Site 2

Measure1

Measure 2

Measure 3

[parry2k · Accepted solution]

@NZCraig if you a create a matrix visual :

site column on rows

week column on columns

measure 1, 2, 3 on on values

and in the formatting pane, turn on "Show on rows" and that will do it.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[NZCraig]

Amazing, thank you so much, now to sort the week columns into actual order and I'm away (changover in the year has me guessing!)