In our site we use a color coding system to allow for someone to quickly check what the current color of the week is and they'll know exactly which work instructions to pull from. With the implementation of digital signage we began dabbling in ways to digitalize some of our old paper processes, this being one of them.
I was fiddling with our signage and it seems I could very easily do a simple 3x2 table that showed the relevant information like this:
| Last Week | Current Week | Next week |
| Insert appropriate color here | Insert appropriate color here | Insert appropriate color here |
There are six possible colors and they go in order then repeat, so (for 2022):
1/2/22 - Blue
1/9/22 - Pink
1/16/22 - Black
1/23/22 - Orange
1/30/22 - Purple
2/6/22 - Green
2/13/22 - Blue
etc...
With our current system, I can easily create a simple Word/Excel sheet with a 3x2 as shown above and display it, however, I would need to make 52 of these and make 52 scheduled display rotations each year. This is a lot of entries to make, expecially considering the schedules change throughtout the year, so we would constantly be working around these schedules.
The digitial signage does allow for Power BI pages, so I was wondering if anyone had any idea how I could make this happen automatically in Power BI, because that would save us a load of time. I'm new to Power BI so I'm going to tinker with this, but any guidance would be helpful, especially if anyone thinks this is not possible.
For clarification, the dates do not matter for the purpose of the data display. If it's possible to just shift the colors once a week that is all that is required for the signage. It may be useful in the dataset, for some sort of processing but it is not required for my use case.
