Forum Discussion
Dynamic labels for cluster column chart to change based on the slicer
- 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
- 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.
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
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.