Forum Discussion
Helper IICard that Drills into a Table
In my dashboard I have a card that filters on specific items and provides the COUNTROWS number.
What I am wanting to acheive is that I can click into the card and drill into a table with set columns to show the records that make up the COUNTROWS figure
Is this possible? If so, how customizable is the table that it drills into?
3 Replies
- VahidDM
Super User
Hey Austen229022
You can add the drill through using the new card.
Please use the attached file.
set filters and right click on the card to drill through the details.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Austen229022I have tried this though on the drill through page I am not able to get the same filters on the table as my measure.
My measure is:1.1.3 PL Renewal Applications = CALCULATE(COUNTROWS(DIM_Application), FILTER(DIM_Application, DIM_Application[Application State Name] = "Active"), FILTER(DIM_Application, DIM_Application[Application Type Name] = "Renewal"), FILTER(DIM_Application, DIM_Application[Regime Name] = "EW"), FILTER(DIM_Application, ISBLANK(DIM_Application[Outcome Reason])), FILTER(DIM_Application, ISBLANK(DIM_Application[Application Outcome Name])), FILTER(DIM_Application, DIM_Application[Application Stage Name] = "Lodgement" || DIM_Application[Application Stage Name] = "Assessment" || DIM_Application[Application Stage Name] = "Decision"), FILTER(DIM_Application, DIM_Application[Payment Complete] = "Yes"))I have a filter in the measure where is is looking for OR with 3 stages that I am looking for. Mayb this is stopping the filters from working?
Also I am wanting to have multiple cards like this that filter into the same table, is this possible?
- samratpbi
Hi,
as per my understanding, Card doesnt have drill-down feature. However you could create a separate page with a table visual and have the same set of slicers that you are applying in your 1st page and make those as Sync Slicers. Hence that table will have same no of rows which is showing in countrows for the KPI. You may hide those sync slicers in the page with table visuals, if you want.
Now on top of card visual, put an empty button with transparent background and do a page navigation to the Page containing table visual and in that page add a BACK button to go back to main page.Hope this helps to resolve your problem. If it does, then please mark it as solution, Thanks!
