Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Visual to show selected as total

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!

2 Replies

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

     

  • DavisBI's avatar
    DavisBI
    Icon for Solution Specialist rankSolution Specialist

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