Forum Discussion
Dynamic labels for cluster column chart to change based on the slicer
Hi Odn_ndO ,
Please have a try.
Create a column.
YearLabel = YEAR('Table'[date])
Drag the calculated column to the Axis field of your clustered column chart. This will ensure that the axis labels reflect the years present in the data after being filtered by the slicer. Make sure your slicer is correctly configured to filter the data by year. It should be connected to the same date field or a related table that allows the slicer to control the year displayed in the chart.
I have also found a similar post, please refer to it to see if it helps you.
Solved: Dinamically change formatting of data labels in a ... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If I have misunderstood your meaning , please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I managed to find a solution for this where I used the Parameter Field Function and added the years needed as per below and is able to achieve the results i am looking for.
Thank you for your advise.