Forum Discussion
Dynamic Matrix Table with dynamic column headers
Hi Anonymous ,
You could use Conditional Formatting. Use 1 and 0 instead of Actual and Forecast. Then use the measure as rule.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formattingBest Regards,
Jay
Hi CNENFRNL ,
thank you for quick help. I would like to do matrix table where each month is a separte column. I think I can adopt the code for the measure.
The final Matrix table should look like this:
| Cost type | Jan | Feb | Mar | May | June | July | Aug | Sept | Oct |
| US100 | xxx | xxx | xxx | xxx | xxx | xxx | xxx | xxx | xxx |
So now I would add calculated columns for each month and post your code.
Now the question is, how can I highlight in the column header, which month is an actual or a forecast?
Thank you and best regards,
Albert
Hi Anonymous ,
You could use Conditional Formatting. Use 1 and 0 instead of Actual and Forecast. Then use the measure as rule.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Best Regards,
Jay