Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is it possible to drill down into a total on a card? or into table to show where that data is making up that visual.
Ex. I have a total bookings card with $XXXX I want to be able to click on that and see what jobs are making up this dollar amount. Same with the table visual. I have a customer and total for the year on each customer. Id like to be able to click the customer and show a list of jobs make up that total.
Solved! Go to Solution.
As has been mentioned, you can set up a drill through page for a table visual.
As regards a card visual, you cannot set up a drill through page. You can however set up a report page tooltip for a card (and for a table for that matter).
Here are a couple of examples in case you are interested:
The report page tooltips refer to the following data (for your reference):
1) Card Visual with report page tooltip type column chart
2) Card visual with report page tooltip type table
3) Table visual with report page tooltip type column chart:
Does this help?
Proud to be a Super User!
Paul on Linkedin.
As has been mentioned, you can set up a drill through page for a table visual.
As regards a card visual, you cannot set up a drill through page. You can however set up a report page tooltip for a card (and for a table for that matter).
Here are a couple of examples in case you are interested:
The report page tooltips refer to the following data (for your reference):
1) Card Visual with report page tooltip type column chart
2) Card visual with report page tooltip type table
3) Table visual with report page tooltip type column chart:
Does this help?
Proud to be a Super User!
Paul on Linkedin.
@edhans ,
my apologies, I forgot to add a link for the bookmark solution/workaround:
https://community.powerbi.com/t5/Desktop/Drillthrough-on-card-or-button/td-p/598378
It's a bit limited in that it will not pass any filtering unless filters are passed to the bookmark through synced slicers.
I cannot find anything in that thread about assigning a bookmark to a card.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe workaround would be to create a button, indicating possibility to further drilldown, with a bookmark action to e.g. another page. Crossfiltering from other visuals will not be filtering the other page, but synced slicers will
Hi @Jmccoy ,
with cards you have to options:
bookmarks: https://community.powerbi.com/t5/Desktop/Drillthrough-on-card-or-button/td-p/598378
or tooltips: https://docs.microsoft.com/nb-no/power-bi/desktop-tooltips
For your table I guess the drillthroug feature will be the right choice:
https://docs.microsoft.com/nb-no/power-bi/desktop-drillthrough
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
How do you do a bookmark on a card @sturlaws ?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |