Forum Discussion
Helper IDynamic labels for cluster column chart to change based on the slicer
Helper IHi Rita,
The desired results would be that the data label changes based on the year selected in the slicer.
Given that the slicer shows the current year,I would like to have the current year and 3 years prior.
Super UserHi Odn_ndO
If I understood you correctly you are trying to add a label for the year of each column.
This option is not available as a generic functionality.
If you want to show the years you should use hierarchies instead of the legend:
If you want to use different colors to code the years you can add to the date table, the code color for every year.
and use conditional formatting for the columns's colors.
Result:
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Odn_ndO
Based on the above, 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.