Forum Discussion

Arranafc19's avatar
Arranafc19
Helper IV
6 years ago

Creating drilldown report on Matrix visual

Hi ,   I am looking for some guidance on how to create a drillthrough report from a matrix visual.   I have a simple dataset called "StatusTracker" which is used to track all statuses of an order...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Arranafc19,

According to your description, it sounds like you are trying to drill through summarized value instead of drill through a single filed, right?

If this is a case, you need to use configure this aggregated value fields as drill through filter, then power bi will bring all related category fields with current row contents value and value as the filter and conditions to apply on the target report page instead of direct drill through summarize value. (aggregated value can't direct mapping to specific records)

Please take a look at the following link to know more about this:

Set up drill through in Power BI reports#add-a-measure-to-drill-through 
Regards,

Xiaoxin Sheng

  • Arranafc19's avatar
    Arranafc19
    Helper IV
    6 years ago

    Hi

     

    Anonymousand amitchandak 

     

    Thanks for getting back to me .

     

    Essentially what I am trying to do is get a row level breakdown of the data that is being grouped by my matrix.

     

    I am able to do this by selecting the "show data point as table" when I right click on the a  number in the visual, however I would like to be able to choose what data is show here in the breakdown , what order it is displayed and have the ability to futher drilldown that.

     

    I have used drilldowns before , But just not sure how I apply this to a matrix visual