Is it possible to create a smart dropdown filter?

[Kate]

Attention all Jira reporting gurus!

One of the areas of our organisation is utilising Jira to manage our Enterprise Initiatives/Projects through a highly structured web of Initiative Tasks/Sub-tasks.

We are currently pulling information out of Jira into PowerBI in order to build reporting on these pieces of work, but after issues with PowerBI and a lack of expert-level knowledge in data transformation in that tool, we're hoping to try and get the required reporting working within Jira or Confluence itself. Might not be possible, but worth an ask!

Here's what I'm hoping might be possible:
🥇 Dream goal: Create a dropdown of the Initiative Issues that can self-populate from a filter of all open initiatives. 

🎖️ Dream Usage: Utilise this drop down to filter information down to that relating to the Initiative Issue selected. 

 If it isn't possible to have the dropdown self-populate from a filter, this is a high enough priority area that we would be willing to manually modify if necessary (These are multi-year Initiatives which don't change often). 

Custom Charts does allow users to create Filter buttons (in a similar manner to board Quick filters), but the dropdown would be my ultimate goal.

Tools/Add-ons we have access to utilise at current:
Jira 
Confluence 
Custom Charts Add-On

[Karim ABO HASHISH · Accepted solution]

hi @Kate 

For the custom chart addon, there is a workaround explained in the below thread by someone from custom charts team. thanks to check if it could make your dreams come true

https://community.atlassian.com/t5/Jira-questions/Custom-Chart-with-dropdown-filter/qaq-p/1859859

[Kate]

Ooooo this looks very much what I'm looking for. Thank you @Karim ABO HASHISH 

[Karim ABO HASHISH]

you're welcomed @Kate 😊