Yearly Comparisons When Drilling Down

[CPESAdminII]

Hello,

I am building my second Power BI report and am trying to get a specific visual result when I drill down. I am not sure if it should be done with Measures or if there is a simpler way of achieving the results I am looking for.

I have created a SQL query and imported a table that has a date range and costs.

At the highest level of the chart I see a comparison of three different companies accross a span of three years.

When I drill down into the present year, I want to see cost data from the present year and the two previous years as well.

In essence I want to drill down into the chart and contiue to see the comparison by year for ever more granular data.

Is this possible?

[austinsense]

Your explanation is a little confusing.

• You want 1) to drill into the current year and 2) still see the previous two years - Those two things are incompatible with each other.
• You're saying that you want to continue to see the YoY comparison as you drill to "ever more granular data" - What exactly are you drilling into?

I think your issue is probably very solvable.  Maybe try to explain it a little differently or show some screenshots.

[CPESAdminII]

I don't quite believe it's possible, but I will try to clarify.

I want to start with the first view but be able to drill down to the second...

What I want to do is to be able to see the data on a yearly basis continuously as I delve deeper into the chart.

Let's say the first view is the yearly profits of three companies and the second view is the profits of divisions of the three companies

[nikil]

This may not be possible with a single visual and using drill functionality. You should consider having multiple visuals on the same page and use the "Edit Interaction" feature to control which visuals filter and whicn ones don't. This enables you can make display prior year numbers while you are filtering/drilling current year visuals.

Hope this helps.

Check out the Chicagoland Power BI User Group

[austinsense · Accepted solution]

Ok gotcha - you want to put the drill path in the axis and the years in the legend - that should do it.  You can adjust what shows up in the report in the filters section.