Forum Discussion
Detailed Data
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
Thanks Lin.
I had a look at this and I could see that you have advised to use table visual for each dataset.
However, the details what user wants to see, is stored in one table only.
So, there is no use if I create different table visuals and drill through to those created tables.
Any solution to drill through to one table would be appreciated.
Also, when I say it shows the data for Sub Category 1 when I drill through for Sub Category 2, that means the same what I explained above that user wants to see the data for DataSet1 only.
HI Anonymous
to my knowledge, it couldn't achieve in power bi for now use drillthrough for different table,
I would suggest append or union different tables into one table, then your requirement will be achieved.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Regards,
Lin
If I do it that way, different table for different dataset, how would I put my consolidated measure(Summary Value)?
I tried by putting individual measure in detailed page , but it's nt showing me an option for drill through.
And if I put the consolidated measure(Summary Value) in each table, then in summary report, it will give me options to all the pages when I try to drill through.
hi Anonymous
add a tag column before append them into one table, then when I would suggest you drag this tag column into matrix too, now when drillthrough, this row context will be passed to details page too.
Regards,
Lin
hi v-lili6-msft
Please have a look at the below image-
I have created different table for differeent dataset on different pages.
SO this way after doing a right click for drill through, it will give all options for drill through.
There should be only one option and not multiple.
hi Anonymous
In power bi, there will be only multiple option and not only one, as i said above, you use IF/SWITCH Function to custom judge which dataset should show in current row context, but power bi couldn't identify this logic.
If this way, I would suggest you rename each page name by each dataset name that help users to understand it well.
Regards,
Lin
Hi v-lili6-msft ,
Thanks you for your suggestion.
I am proceeding that way however the problem I am facing here is, it's working for measures but not for calculated columns.
Isn't is supposed to work for calculated columns?
Like, according to my sample pbix, it works for SubCategory 1 (assuming it to be a measure) however not working for Sub Category 2 (measure derived from a calculated column).