Forum Discussion

Odn_ndO's avatar
Odn_ndO
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamic labels for cluster column chart to change based on the slicer

I've successfully created a dynamic clustered column chart where the data changes according to the selected years in my slicer, I'm facing an issue with the year labels. I want the naming of the year...
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi 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's avatar
    Odn_ndO
    2 years ago

    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.