Tooltip page - Show percentage in the Stacked Bar Chart

[Anonymous]

Hi everyone, I have the next issue:

In my datasource I have a order and this order can have different type of cancellations, in this chart Im showing all cancellation with the type Influencable:

This is the measure that Im using to calculate the number of influencable cancellation:

Count INF Cancellation = CALCULATE(

DISTINCTCOUNT(OrderDetails[OrderID])+0,

FILTER(OrderDetails,OrderDetails[Cancellation Type]="Influenceable"))

I have to show in the tool tip of each bar, the total percent, really would be easy if I add the measure "Count INF Cancellation" to the tooltip and I put to show the value like "percent of grand total":

Which is the problem? My problem is that in the tooltip only want to show the percentage, not the other values like the reason and "Count INF Cancellation", like is not possible to remove this values from the tooltip of this bar chart, the only way would be to create a tooltip page that show this percentage, but Im not sure how to create this measure, until now the my measure created always show the 100% beause is applying automaticallyt the filter of reason type in the different bar of the chart.

Any idea o suggestion? Thanks a lot.

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to create a new measure with the following code:

Count INF Cancellation =
DIVIDE (
    [Count INF Cancellation],
    CALCULATE ( [Count INF Cancellation], ALL ( Table[Reasons] ) )
)

If this does not work can you share a small sample of your data please.

[Anonymous]

Thanks @MFelix , I was using in my measure the function AllSelected instead of ALL and in the tooltip always showed 100%.

Thanks a lot!