Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

how to combine multiple data sources, measures into one data set to use as a stacked bar chart.

Hi,   I have a fair bit of experience using powerbi service but have just started trying to use powerbi desktop to automate some of my exsiting reports. I have one where I have aprox 15 sharepoint ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

data type is text which i am performing a countifs equivalent measure 4 times on to produce a number. It's these numbers i want to pull as a live connection together to create the chart from

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    The poster above is correct, you'd need to append your tables. Before you append, you can create a custom column with the text label you want to show in each to use in the visual as the legend. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      WHen I tried doing this earlier custom columns werent pulled through when the tables were apended. Any tips on how to do this?

      • christinepayton's avatar
        christinepayton
        Icon for Most Valuable Professional rankMost Valuable Professional
        2 years ago

        They come through. Make sure they are named the same between tables if you want them to line up together in the final table and that your append step is after the step where the columns are created. 🙂