Forum Discussion
Different Drillthrough depending on dimension value
Say I have a very simple report displaying income and expenditure with drillthrough options
as pictured
Is there any way I can have a different drillthrough for income and expenditure
So, for example, income will only show the Drillthrough1 option and expense will only show the drillthrough 2 option
Can I restrict drillthorugh based on the dimension or any other method?
Thanks
4 Replies
You might want to try the idea by Anonymous detailed below.
"You can do so by cloning a column in the power query editor and use that column renamed to distinguish a drillthrough to tab1 or tab2.
Say you have a column named "Process". Clone another one Named "Process1" in the Query Editor.
In drillthrough filters of tab1 use "Process" and in the drillthrough filters of tab2 use "Process1".
Your upstream visuals then can distinguishedly drill down to the desired page / visual."
Sourced from here:
Thanks for the quick reply
I think because my data is in single visual - essentially a profit and loss report this wont work since the value column is used by both in the report
If I split the report into an income visual returning values from column1 and an expense visual returning values from column2 I think yes it will work but ideally I want all this information in a single visual
However, you have given me an idea, if I can create a measure that returns either coumn1 or column2 based on the dimension value in another column I might be able to get that to work based on your logic
I should also mention I have managed to get both drillthroughs on the same page using filtering (both drillthrough visuals same page but one visual is always blank)
If I can figure out how to hide or dynamically size visuals then this would satisfy my requirements
