CODEWITHSUNDEEP
powerbi
taylorswiftfan
taylorswiftfan

Reputation: 1517

Display the level the user is at during a "drill down" in PowerBI

Let's say if I were to have a clustered bar chart on Power BI that have a pseudo-structure like this:

{" A": [
    {"A1": 1},
    {"A2": 2},
    {"A3": [
        {"A3-1": 1},
        {"A3-2": 2},
        {"A3-3": 3}
    ]}
]}

Where A3 reflects the lowest number in the child elements (which is 1) and A reflects the lowest number in the child elements (which is also 1).

Upon loading the chart, the user has the ability to right-click to drill down from the first level to reveal the value for A1, A2 and A3. The same can be done for drilling down to A3.

I am wondering if a visual indicator can be created to show the user the depth s/he is at during the drilling down process? e.g. If the user is at the second level, an indicator to show the user is at the second level.

Thank you kindly.

Upvotes: 2

Views: 2514

Answers (1)

Leonard
Leonard

Reputation: 2578

Speaking only about the built-in clustered bar chart visual, this isn't built-in functionality in Power BI.

However, the built-in bar chart visual does provide an indicator of where you are in a hierarchy. For example, in the below picture, I've drilled down 3 times (Year > Quarter > Month) and am now showing a breakdown by the 4th level (Date).

Drilled Down Title

The up-arrow in the top-left (indicated by a blue triangle) further indicates that I've drilled down and the greyed-out adjacent arrows indicate I'm at the lowest level. This isn't a numeric indicator and isn't as clear as a breadcrumb would be, but it is an indicator of the level you've drilled to.

In terms of a numeric indicator, it is possible a custom visual handles this better (now or in the future) or, though this is likely overkill, you could consider writing your own. Existing custom visuals can be found here: https://app.powerbi.com/visuals.

After reading this, you might be tempted to roll your own indicator via a separate DAX measure overlaid on top of the bar chart (using HASONEFILTER or HASONEVALUE for example).

I do not recommend this approach because an independent visual would rely on being cross-filtered by the bar chart when the user drills down. Right now, however, this does not happen, so the overlaid visual would have no way of knowing that a drill-down has happened. More information can be found here (and you can vote to fix this): https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6709520-drill-down-should-drill-or-cross-filter-other-visu

Upvotes: 0

Related Questions