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.
Well I’m sure that default visuals in Power BI do not have this type of functionality but not sure if there are customized visuals available which offer such types of functionalities. What you can do is show type of visuals using drill through option. Recently one of our expert member @Melissa had used this option in one of the challenge. And a video was also created based on this topic. I’m providing a link of that video and some other videos as well.
Hi @YWJ, did the response provided by the contributors help you solve your query? If not, how far did you get, and what kind of help you need further? If yes, kindly mark the thread as solved. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. Thanks!
Hi @YWJ, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
Hello YWJ,
Did you try building the pop up using bookmarks? You can achieve a similar behavior.
Or you can use tooltips and reduce the number of clicks.
) but hope this helps.