Forum Discussion
Dynamic column headers in matrix visual
If you have still not found a solution - I have made a video on this specific requirement - do check it out and let me know if this helps!
Stop Using Static Headers! Create a Fully Dynamic Power BI Matrix | MiTutorials
Apologies, guys. Sorry for the delayed reply. Occupied with other work.
I haven't implemented the suggestions. But checked the miTutorials solution, it will work for me. danextian's suggestions are aslo useful for my other requirements.
Hi rahul-opp
You will need a disconnected table that contains a column containing the dates, week numbers, the words YTD, Current and Target and their categorization (MTD, Units), their custom column sort and then a measure referencing the values in the first column. What you're trying to achieve is not impossible but definitely not for the beginners. Please see attached sample pbix files.