Forum Discussion
Solved
Drillthrough Help
Hi there, In the below example, Is there a way to drillthrough on the homepage below from either of the two measures, to the destination page to show the sales ID's that are applicable? I can...
Hi lherbert501 ,
Thank you SamWiseOwl for the helpful response!
Since Power BI doesn’t currently support measure-level drillthrough cleanly when multiple measures are used on the same visual. I recommend posting this idea in the Power BI Ideas forum. That way, the product team may consider adding support for drillthrough based on individual measures without needing a workaround.
Hope this helps.If so,give us kudos and consider accepting it as solution.
Thank you
Regards,
Pallavi.
Hi lherbert501
You could create a second measure to use on the drillthrough page:
Hide Category Sales = If( CALCULATE(COUNT(Sales[Salesid]),Sales[category] = "IT"), " ", BLANK())
Set the visual column aliase to a space and the column is effecitvely hidden:
Or set it in the Filter Pane as a visual level filter that returns not blank.
Then set this filter to hidden using the eye ball:
I don't see why it wouldn't.
