Forum Discussion
How to create dynamic column headers & custom conditional formatting (match an easy Excel process)
Hi Anonymous ，
The following article describes in detail about Power BI Conditional Formatting for Matrix and Table Visuals.Refer it and check if it could help you solved your question about Conditional Formatting.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
I've solved half of this via trial and error, if anyone stumbles across the dynamic column headers question and is wondering:
I brought several start of month dates into a test table (way more than I required), with dummy values assigned. Then I sorted the list in PQ by date ascending (sorting via Table.Buffer to ensure the sorting locks in). Then, I selected the matrix table and put the dates into columns and set the filter to the last 13 calendar months.
Actually quite a simple fix to what I was expecting to be more of a complex problem!