Forum Discussion
Funnel Chart - Multiple Values no Category Interaction
Hi Team,
I created a Funnel chart that contains three columns (KPIs) - Lead, Opportunity, and Customer (having values 1 and 0). The Visual looks great but I have created a detailed tabular data below which I want it to interact with.
The tabular data contains more information about these three KPIs including names and addresses. What I want is when I select any one of the stages from the funnel chart eg - opportunity, the tabular data gets filtered and shows only records which are at the opportunity stage. Same goes for lead and customer.
Unfortunately, since these are metrics, the interactive filtering is not working. Is there a way I can get it to work?
3 Replies
Hi sanjay_nm
Check the Drill Through option:
https://www.youtube.com/watch?v=BbplhqDCWOMIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983, thank you for the suggestion! I had seen this video before, but I wanted to see if we can achieve interactive filtering as that would be ideal. I have seen interactive filtering done in such cases in Tableau so I just wanted to know if it can be achieved in Power BI as well via some data modeling
Hi sanjay_nm , do you solve this? if yes, could you please elaborate the solution?
