Skip to main content

Power BI

Needs Votes

Drill Down with Field Choice

Vote (2) Share
's profile image

on 09 Jun 2017 20:39:44

I have a Sales Report showing Column DivisionName, MonthName. Data Value as SalesValue.
I want to drill down Division to next level by ProductCategory or Product or Country Level. This drill down choice is for user to decide. How Can we achieve this.

Comments (2)
's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:21

RE: Drill Down with Field Choice

We would like to drill into data, all the way in to the sales order.

's profile image Profile Picture

Cherie on 05 Jul 2020 23:17:27

RE: Drill Down with Field Choice

I would set up multiple matrix visuals on the same page. Matrix 1 = Division; Matrix 2 = Products Category; Matrix 3 = Product; Matrix 4 = Country. Then when they click on a division they will see a summary of each of the matrix info for 2-4. Or use the drill through feature for pages of each.