Forum Discussion
Detailed Data
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).