Forum Discussion
Detailed Data
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
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.
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
Hi Lin,
I have placed a sample pbix here.
If you open the PBIX, and when drill through for Sub Category 2 , it will show the data for Sub Category 1.
The point here is, I am trying to drill through (for DataSet 2) to another table (DataSet) where the details arae stored.
Please provide a cool solution for this so that I can drill through to another table.
In the original file, I have multiple datsets and I am trying to drill through to only one table where detailed are stored.
hi Anonymous
First, when you drillthrough from page 1 to page 2. all the row context will be passed to page 2.
for example:
so it could not happen that it will show the data for Sub Category 1.
and you should use a table visual for each table DataSet, since in your case, you are using IF/SWITCH funtion to judge what measure(table DataSet ) to use in current row context, but 'drillthrough' couldn't judge this.
I would add a title for each table visual as a tag for them like below:
here is sample pbix, please try it.
Regards,
Lin