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 and looks like this :

 

Status          Date Created  Order ID

Paid                  02/02            91

Paid                 29/04             45

Closed              14/05            21

Dispatched     01/01             45

 

 

 

I then from there , have createad a matrix which groups a count of order ids by status per day and this looks like the below :

 

 

I need to create a drillthrough report which will allow me to select a number , and it will show the status breakdown and ids for that date.

 

For example , if I select the number 5on the 02/02/2020 for the paid status , i want to be able to see the breakdown of the 5 cases that are being counted.

 

Can anyone assist with this please ?

 

Thanks

 

Arran

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • 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