Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Detailed Data

I have a matrix report where data is being shown from multiple sources. Drill through is not working properly in this case and the requirement is to show the corresponding records from the matrix. ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , too little information to provide ant solution.

Drillthrough or report tooltip should work

 

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I'll try to elaborate here the situation. I am visualizing a matrix (shown below) where data is coming from multiple sources (tables) and measures.

So, I have 6 categories and for samplee I am just showing 3 categories which further have multiple categories.

The 3 tables which are beig used here are interrelated on a common field and one of then is connected to date table.

 

Now the problem I am facing here is , I am not able to drill through to the detailed data page which I have created.

 

What can be edone to show the data behind the counts, any deep link or any other suggestion?

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    5 years ago

    hi  Anonymous 

     I am visualizing a matrix (shown below) where data is coming from multiple sources (tables) and measures.

    How do you put different table measure into one matrix that could show as your example?

    If possible, please share your simple sample pbix file, that will be a great help.

     

    Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for coming back to me.

       

      To answer your question -"How do you put different table measure into one matrix that could show as your example?", I have given the measure which I am using to consolidate the values from different tables.

       

       

      Above is just a sample for one category and similarly, I have added for other categories and this is being used to populate the data in matrix.

       

      The Summary Data table is connected to date table which is further connected to other tables.

       

      Let me know if you need further details and please advise a solution.

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        5 years ago

        hi Anonymous 

        For your case, basically, when use drill through, only 'Category' and 'Date' of the row context will be a filter to pass detail page, so you need to use the same logic to create measure in detail page.

         

         

        If the data structure of these tables are same, i would suggest you append them into one table, that will be very convenient for modeling.

         

        If you still have the problem, please share a simple sample pbix file.

         

        Regards,

        Lin