Microsoft BI Professionals Denmark

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

View My Drafts

Back to discussions
Expand all | Collapse all

distribute the values of one column in a chart to the others based on the size of the other columns

  • 1.  distribute the values of one column in a chart to the others based on the size of the other columns

    Posted Aug 28, 2020 04:12 AM

    Kære Alle, håber nogen kan hjælpe os på vej med følgende.


    We are trying to find a way to distribute the values of one column in a chart to the others based on the size of the other columns.

    Say we have one column with turnover from webshop sales, and some other columns with sales for a number of stores. We want to be able to destitute the webshop turnover to the physic shops for accounting reasons. Preferably we would like to do it on row basis, so that it is still possible to divide sales by product.

    Can somebody please help us giving their thought on where the solution should be performed, in the visualization, as a calculated column etc.

     

    Thanks

    //Jacob

    ​

    ------------------------------
    Jacob Birk
    ------------------------------