Forum Discussion
Dynamic Column for values by year
Hi Nimai,
I'm not sure if that is possible in Power BI but there is a workaround for this. I've tried to recreate your use case with sample data and this is what I've achieved.
You need to create an additional KPI table for this- I've added the values in the year column up to 2030 (you can add more if required).
If there were sales available for the particular year then one column will be automatically added to this matrix.
For ex- If you add the Sales for 2025 in the sample excel sheet and hit refresh it will automatically add one column in the matrix named "2025" under sales which will show the sales for the year 2025.
I hope this suffices your requirements. ThanksFiles-
https://docs.google.com/spreadsheets/d/1edW2FHS2qltGZiJ8TUmS3JAbGgo29le-/edit?usp=sharing&ouid=101701281295966826492&rtpof=true&sd=true
https://drive.google.com/file/d/1kNKmA8synCCvomaUrnJtpUxJBBmiSs7N/view?usp=sharing
Hi Nimai,
I'm not sure if that is possible in Power BI but there is a workaround for this. I've tried to recreate your use case with sample data and this is what I've achieved.
You need to create an additional KPI table for this- I've added the values in the year column up to 2030 (you can add more if required).
If there were sales available for the particular year then one column will be automatically added to this matrix.
For ex- If you add the Sales for 2025 in the sample excel sheet and hit refresh it will automatically add one column in the matrix named "2025" under sales which will show the sales for the year 2025.
I hope this suffices your requirements. Thanks
Files-
https://docs.google.com/spreadsheets/d/1edW2FHS2qltGZiJ8TUmS3JAbGgo29le-/edit?usp=sharing&ouid=101701281295966826492&rtpof=true&sd=true
https://drive.google.com/file/d/1kNKmA8synCCvomaUrnJtpUxJBBmiSs7N/view?usp=sharing