In my report page, I have two column charts that show the last five years absenteeism trend and last Twelve Months Absenteeism trend. In my first column chart, I want to create a column chart that allows the end-user to left-click on one of the bars and display a pop-up table visual that contains records that is related to a selected bar clicked by the end-user. For example, if the user clicks on the Year 2020 bar absenteeism column chart, it will display a pop-up table that contains the Year 2020 absenteeism record.
Appreciate your help if you can guide me on how to create the above requirement.
PS I have attached a sample video below that describe the above requirements.
Thanks & Best Regards