Forum Discussion
Yearly Comparisons When Drilling Down
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?
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.
4 Replies
- austinsense
Impactful Individual
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.
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
- austinsense
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.
