Forum Discussion
Conditional shape fill based on date in table
- 2 years ago
I went to Synoptic Designer for Power BI and it created the attached SVG for me. (Please unzip before use)
Use that with the Synoptic Panel visual, or with your own HTML5 visual.
Hi IbendIin,
Thanks for reaching out.
So I added a picture of what I currently have, it is a dummy file (.pbix which I cannot add here).
It is a very basic recreation of what I have:
- a plotplan with multiple areas
- a table with the area names and dates
- a shape (I want to cover all the individual areas with individual shapes and the shapes should be coloured based on the date linked to the area name in the tabel. Colors based on conditional formatting which I did with a measure, see measure in original message)
How can I link a shape to the color of the cells in the table?
So I have a working excel file where dates may change, which should then automatically change the color of the cell with the area name. This should then change the color of the shape that is linked to that so that in the overview of the plot plan, the areas change color.
| Area name | Date |
| Meeting Room | 11/01/2023 |
| Office 1 | 11/01/2023 |
| Office 2 | 01/01/2024 |
| Office 3 | 02/01/2024 |
| Office 4 | 12/01/2023 |
- lbendlin2 years agoSuper User
I went to Synoptic Designer for Power BI and it created the attached SVG for me. (Please unzip before use)
Use that with the Synoptic Panel visual, or with your own HTML5 visual.