I have a few count KPIs on top of a sheet in my dashboard. I want the user to be able to click the KPI number and see the related details that make up that KPI in a table visual on that same sheet.
This filtered interaction is working for all other visuals I have tried like bar graphs etc, but not with KPI.
As an alternate I tried to add a navigation interaction to the KPI, to show the details in another sheet in the same dashboard, but then I can’t figure out how to send the “filters” from the KPI, so that the detailed info sheet only shows the filtered rows.
Did @imaitri’s reply provide a solution? If so, please mark their reply as solution. If we do not hear back in the next 3 days, we will archive the question.