Creating Customized Legend and Tooltip for Clustered Column Chart
Hi everyone! I hope you can help me with a visualization challenge I'm facing. I have created a clustered column chart to display year-on-year (YoY) inflation based on different cities. The chart shows two columns for each city: one for the current quarter and year's YoY inflation and the other for the YoY inflation from the previous quarter. I have also filtered the data based on selected quarters and years. Now, my question is: How can I customize the legend and the tooltip to dynamically adjust based on the selected filter values? For instance, if I select "Quarter I" and "2019" from the filters, I want the legend to show "QI 2019" for the current quarter and "QIV 2018" for the previous quarter. Similarly, I want the tooltip to display the respective inflation values for the selected quarters. Is there a way to achieve this in Power BI? I would greatly appreciate any insights or solutions you can provide. Here I attached an illustration of my current chart for reference. Thank you in advance for your help! ❤️
