Forum Discussion
Stack columns
Hello, everyone.
I'm new to using Power BI and I'm taking my first steps.
I would like to stack these columns by day by placing the cities for day 1 on top of each other. The same for day 2, and so on.
I'm just working out how it looks. In other words, I'm seeing the different invoices by city for day 1, and then for day 2.
I want to see the different invoices by stacking the 3 different cities, for day 1, then for day 2, also stacking the three cities, and so on.
How should I do this? Can anyone help me?
I'd like to do something like this
9 Replies
Hello, thank you very much for your reply.
The legend only lets me enter one field, either Invoice_ID or City. It doesn't allow both at the same time
So putting the City column in the legend field doesn't work
As you can see in the image, I have different colours for the invoices on a particular day of the month (in this case it's day 1). This image is not what I want.
I want to group all three cities together in a stacked column (each with its own colour) so that I can see the different invoices for the 3 cities for day 1.
In other words, the stacked column will have the 1st city with the respective invoices. Then, in the same column, the 2nd city, now in a different colour, will have its invoices. And finally the 3rd city, third colour, in the same column, with its invoices.
It's showing the invoices for the selected day, but I want it to AGGREGATE the invoices for a city. Put them all together. Then group together the invoices from the 2nd city, placing them all together, and finally from the 3rd city, placing them all together. Each city will have a different colour, showing the slices that correspond to the invoices.
Have you understood what I'm trying to say or not yet?P. S.: I only have 3 cities. What you're seeing are the different invoices per city.
