Aggregate

[powerbiquestion]

I am trying to display revenue over time in a stacked bar chart. Power Bi is multiplying the product by the price to get the revenue but it is also multiplying it by the number of products I have selected in my slicer. 

I do not want it to multiply by the number of products I select in my slicer.

Solutions?

[v-piga-msft]

Hi @powerbiquestion,

It seems that you are creating a stacked bar chart to display the revenue over time?

However, I 'm not clear about your scenario based your description so I cannot repreduce it. Could you specify your issue with some screenshots?

I would appreciate it if you could share some data sample and your expected output.

Best Regards,

Cherry