drill through using detail

[Anonymous]

Hi, in a visual i can easily drill through using the category..  In the example below  of statuses, i can easily drill through to look at the data. 
|But the numbers are based on the count of each ID. When I bring this status into the drill through category, works great. But I want to use the ID instead, to drill through to the page (there are multiple ID's in each of these Statuses.

Any idea how i can achieve it? It ignore the drill through, despite putting the ID field in the drill through page,

[Anonymous]

Hi  @Anonymous ,

This seems to be impossible to achieve. You must have drilled fields in your page as the target before you can drill.

You can try to set the font color and background color of the City field to white to make it look like this, and you can continue to drill.

Field formatting-select the City field-Font color and Background color are both white.

Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I think you basically got it. 
There's no issues when doing drill down by the legend (Status in this example). But the values that make up the Status, the ID's, i want to drill into my table using those values, rather than the status itself.
It currently ignores it when I try, despite adding the ID field that populates the visual, or the ID that's on the main table.

Did i explain it clearly?

[TomMartens]

Hey @Anonymous ,

please excuse, but I'm slow.

I do not understand what you are looking for.

Can you please describe the visual on the summary page, and the visual on the detail page.

Regards,

Tom

[TomMartens]

Hey @Anonymous ,

I guess I do not fully understand your requirement.

Assuming your report has two pages

1. The first is called summary and contains the chart from your post
2. The second is called detail and contains a table visual
   The table contains the id-column and some measure or numeric columns.
   On the detail page, you add the status column as drill through column.

If you initiate a drill through from the chart on the summary page, just the IDs that form the status should be visualized in the table visual on the detail page.

Does the above not work or do you want something completely different.

Regards,

Tom

[Anonymous]

Hi Tom. Thanks for your effort, but I had a hard time explaining what i wanted to do in this request. So I'm going to cancel it because I created a new one which it think explains my dilemma much clearer.
https://community.powerbi.com/t5/Desktop/Question-about-drillthrough-options/m-p/2076271#M773443