drill through from power bi card

charts powerbi drillthrough
dragonfury2 picture dragonfury2 · Feb 12, 2018 · Viewed 8.7k times · Source

I need some help with drill through. I have a main dashboard with high level aggregated data. I need to drill through to a details report I have created with more granular data. The chart type I have used in the dashboard is a CARD, to which it should drill down from. Only thing is when I right click it does not give the drill option. I have added the relevant field into the details report but still no rightclick --> drill through. Any advice would be great. Could this be a limitation with Power BI?

Answer

Richard Butler picture Richard Butler · May 24, 2018

I agree that it's poor form not to have this sort of functionality. I've tried multiple workarounds, using other visualisations without success. The only thing that i can get to work is to have the card, and overlay a button on top of it (making sure that the button is transparent), which links to a bookmark on that page that i want to 'drill through' to.

Related questions

How to add legend for color saturation distribution into power bi Filled Map chart

i have a power bi report "Filled Map" chart, where Location = "Cedent Country", and Color Saturation = "Percentage Brokerage Over Premium". Percentage Brokerage Over Premium = Percentage Brokerage Over Premium = IFERROR(Round(SUM('Production ReportV20-V1 Power B'[Total Brokerage])/SUM('Production …

Read More
Swap x and y axis without manually swapping values

So I have a set of data that has conditional formatting. Basically it's a set of photometric measurements of stars that I want to put on a chart with different colors for stars in different ranges of Color Index (basically …

Read More
Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n. Say, I want to move …

Read More