Forum Discussion

CPESAdminII's avatar
CPESAdminII
New Member
10 years ago
Solved

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 ac...
Need Help
Tutorial Requests
  • austinsense's avatar
    austinsense
    10 years ago

    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.

     
CPESAdminII's avatar
CPESAdminII
New Member
10 years ago

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's avatar
nikil
Icon for Resolver I rankResolver I
10 years ago

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