Different Drillthrough depending on dimension value

[Ross_PBI]

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

[Anonymous]

Hi Ross,

I am facing same issue can you help how you solved this ....my mai id-ymanikanta19@gmail.com

[Ross_PBI]

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

[Anonymous]

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:

https://community.powerbi.com/t5/Desktop/Restricting-Drillthrough-on-visuals-having-same-columns-as-used/td-p/385361

[Ross_PBI]

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