Visual to show selected as total

[Anonymous]

Hey there,

I have a visual which shows Percentage of revenue/cost.

It shows this for the entire product range displayed on the left hand side as a table.

When I select a single product on the table I would want the visual to show the revenue / cost for that

specific product e.g. 40%-60%. What it shows at the moment is the revenue/cost compared to the total, so e.g. 0.3% and 0.2%.

Is there any way to change the visual so it shows the total for that exact product?

Thanks in advance!

[DavisBI]

@Anonymous  What's your DAX formula (revenue/cost)?

[amitchandak]

@Anonymous , not very clear, you should mark it as % in measure/column tools