Drill Down on a chart based on flag sum

[arimoldi]

Hi,

I have a dataset like this:

DATE	ID	FL_1	FL_2
31/12/2024	A	0	0
31/12/2024	B	1	0
31/12/2024	C	1	-1
31/12/2024	D	0	0
31/12/2024	E	1	0
31/12/2024	F	0	-1

on which I create a chart like this one based on the sum of the flag fields:

I would like to drill down by clicking on the orange box so that I can see the related ID (B, C, E in the example), same by clicking on the blue box; but the drill down option does not appear.

Any idea on how to solve this problem?

Thanks

[arimoldi]

Thanks for your support,

when I add the ID to the chart the drill-down option appears, but when I click on the drill-down button it opens a new page (a hidden drill-down page created by myself with a table to show the IDs) where all the ID are displayed, not just the one selected one in the chart.

In the Keep Filters in the drill-down page I have already added the ID and the FL_1 (summarized) and FL_2 (summarized) and DATE.

How can I make it works?

Thanks,

Andrea

[Ritaf1983]

Hi @arimoldi 

You're mixing up two different things.

Drill Down – This is a drill into the next level of hierarchy within the same visual, without navigating elsewhere to display a different dimension. This is what I demonstrated in my first response, and I also attached an example file.

Drill Through – This action navigates to another page linked to the original visualization while retaining its filters. For example, if we continue with the first response's example, it works as shown in the image.

The updated pix is attached.
Detailed guide for drill through is here :
https://www.youtube.com/watch?v=BbplhqDCWOM&t=11s

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

[arimoldi]

Hi,

thansk for the explanation.

I checked your example, but my case is more similar to the one I attached, meaning that I have also other columns that I have to display in the drill through page and the chart should be based on DATE and not on the category.

Is it possible to have the same view with this new dataset?

https://drive.google.com/file/d/1gVRbwm8uBO5514BZNG5XpRjMRqDqpwzZ/view?usp=sharing

Thanks

[Ritaf1983]

Hi @arimoldi 
To get a desired result, FL should be in 1 column on the x axis.

So you need to unpivot the table from PQ :

More infoemation about umpivot is here :

https://www.youtube.com/watch?v=hGj2axffxHo&t=5s

then you can create a graph with the needed hierarcie :

If you don't wont the zeros be shown than just filter them out:

The pbix is attached

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

[DataNinja777]

Hi @arimoldi ,

A common stumbling block is that most BI tools require a hierarchy or layered dimension in the visual for click‐to‐drill functionality. Simply plotting a measure (the sum of the flags) often does not expose a drilldown option unless the visual also has a lower‐level dimension such as “ID” in the axis or in a defined hierarchy. In Power BI, for example, you can place “Date” on the Axis and “ID” under it, enabling drilldown so that clicking a bar for a given date or for the sum measure reveals the underlying IDs. Alternatively, you can set up a drill‐through page that shows detailed data by ID whenever you right‐click on a bar in the main chart. If you are using a pivot or matrix, placing “Date” at the top level and “ID” at the next level of rows or columns adds expand icons, and the corresponding chart should allow you to drill into the details.

Best regards,