CODEWITHSUNDEEP
powerbidrillthrough
variable
variable

Reputation: 9724

How to decide whether to use dimension column or fact measure in Power BI drill through page

I have a page with table. Columns are: Customer name, Sales count, Sales Amt

Another page with table. Columns are: YearWeek, Sales count, Sales Amt

Another page I want to create for drill through. This has got table with YearWeek, Customer name, Sales count, Sames Amt. On This page what should I add to the drill through fields?

Can someone help me understand whether to add the dimemsion columns or fact measures as drill through fields?

I tried another example:

Page 1 is pie chart with Customer name and Sales Amt

Page 2 is table with Customer name and sales amt

On page 2 irrespective of whether I add Customer name or Sales Amt in the drill through field, the pie chart on Page 1 allows me to do the drill through.

So again my question is - how to decide whether to add the dimemsion column or fact measure as drill through fields?

Upvotes: 0

Views: 306

Answers (1)

Marcus
Marcus

Reputation: 4015

Generally you want to use drill-through as a means of transferring a filter context from a summary type page to a details type page. This means that most use-cases involve using columns as drill-trough filters and not measures.

However, if you have created a page that shows many different slicings of a certain measure, you could add this measure as the drill-through filter. Depending on your choice of "keep all filters", this will also apply any additional (columnar) filters corresponding to the filter context of the point from where you drilled through.

Upvotes: 1

Related Questions