cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JuliaOnStock Frequent Visitor
Frequent Visitor

drilling down \ filtering \ navigating from matix cell

Hi, I am just getting started with Power BI

 

1.My data source is SQL server ,and I am free to design it the way I want

 

2.The DB contain information about products

 

3.I need to display something like the following matrix 

 

Type Quantity Income Cost

A          10          1000     500

B           20         2000      500

C           30         3000      100

ALL       60         6000     1100

 

The martix display information about products , as you can see I have 10 product of type A in the Quantity (can be a single table for each categroy : quantityTable  ,incomeTable ,costTable  or one table for all )

 

Upon clicking 10 , I need to to go to a products report page and display 10 products of Type A from Quantity

Upon clicking Quantity I need  to to go to a products report page and display 60 (All) products from Table Quantity

 

 

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: drilling down \ filtering \ navigating from matrix cell

Hi @JuliaOnStock,

Based on my test, you could refer to below steps:

Sample data:

1.PNG

Create a measure and create a matrix visual in page one

Measure:

Quantity = COUNT(Table2[Type])

2.PNG

Create a tabel in page 2 and add the [Type] column to the 'DRILLTHROUGH' filter.

3.PNG

Now you could get the correct result.

Before click:

1.PNG

After click:

2.PNG

You could download the pbix file to have a view:

https://www.dropbox.com/s/lvf41r8sq4mpzs8/drilling%20down%20%20filtering%20%20navigating%20from%20ma...

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
JuliaOnStock Frequent Visitor
Frequent Visitor

drilling down \ filtering \ navigating from matrix cell

Hi, I am just getting started with Power BI

 

1.My data source is SQL server ,and I am free to design it the way I want

 

2.The DB contain information about products

 

3.I need to display something like the following matrix 

 

Type Quantity Income Cost

A          10          1000     500

B           20         2000      500

C           30         3000      100

ALL       60         6000     1100

 

The martix display information about products , as you can see I have 10 product of type A in the Quantity (can be a single table for each categroy : quantityTable  ,incomeTable ,costTable  or one table for all )

 

Upon clicking 10 , I need to to go to a products report page and display 10 products of Type A from Quantity

Upon clicking Quantity I need  to to go to a products report page and display 60 (All) products from Table Quantity

 

 

 

Thanks in advance

 

Community Support Team
Community Support Team

Re: drilling down \ filtering \ navigating from matrix cell

Hi @JuliaOnStock,

Based on my test, you could refer to below steps:

Sample data:

1.PNG

Create a measure and create a matrix visual in page one

Measure:

Quantity = COUNT(Table2[Type])

2.PNG

Create a tabel in page 2 and add the [Type] column to the 'DRILLTHROUGH' filter.

3.PNG

Now you could get the correct result.

Before click:

1.PNG

After click:

2.PNG

You could download the pbix file to have a view:

https://www.dropbox.com/s/lvf41r8sq4mpzs8/drilling%20down%20%20filtering%20%20navigating%20from%20ma...

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JuliaOnStock Frequent Visitor
Frequent Visitor

Re: drilling down \ filtering \ navigating from matrix cell

Thanks! it is working