Disable right-click drill-up on a visual

[Anonymous]

I turned off Visual Headers on a bar chart because I don't want users to drill up from quarters to years. Drilling up to years makes the values incorrect. But my crafty users have figured out how to right-click a bar on the visual and drill up anyways. 

Any way I can disable the ability for a user to right-click and drill up? The only solution I've found is to change my date hierarchy to a straight-up date, but I don't like the results of that. 

Thank you!

 I want to get rid of the DRILL UP option

[lbendlin]

Wouldn't it be better if you can fix the measure so it produces the right result for the years?

Unrelated note/personal opinion: Your job should be promoting the use of Power BI among your users, not making it harder for them to get stuff done.

[Anonymous]

Drill up produces incorrect values b/c the chart shows the value of a bank account each quarter. If you drill up, it adds them all together, and you get a bank account value that's 4 times as high as it should be. So by restricting drill up, I'm preventing my users from seeing an incorrect value. 

I've temporarily solved the problem by using a non-hierarchical date, but I don't love the solution. 

[lbendlin]

What would be the correct answer?  The average, or the max, or the latest value?

[Anonymous]

Ah, that's an idea, I hadn't thought of changing the aggregation. Will give that a go.