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?