Forum Discussion
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 ...
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
Most Valuable Professional
Most Valuable ProfessionalThe 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.
WHen I tried doing this earlier custom columns werent pulled through when the tables were apended. Any tips on how to do this?
- christinepayton
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. 🙂