Forum Discussion
Update Month year dynamically in Table or matrix visual .
Hi PunitPrabhu ,
According to your sample, I know you have the multiple date values are column headers in your table. And you want your visual to show data in dynamic date range with the changing of month.
I think this is not a good choice to achieve your goal. Power BI doesn't support us to add columns or remove columns automaticlly.
I suggest you to unpivot the multiple date columns which contains data. Rename the attribute column as Date column.
Then your new table will only have Key columns, [Date] column and [Value] colume.
Finally, you can create a Matrix visual to achieve your goal. Add Keycolumns into matrix Row Field, add [Date] column into matrix Column Field and add [Value] column into matrix Value Field.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous Rico Zhou -- Thanks for your response . The solution which you mentioned i did that already. Using that method i need to create 2 separate tables one for Dynamic month and one for other value columns which have currency and number format which works fine. I was checking if its possible with dax measure it can be done in one matrix table itself