Forum Discussion

powerbiquestion's avatar
powerbiquestion
New Member
8 years ago

Aggregate

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?

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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