Forum Discussion
powerbi vs. excel
Hello, I am trying to build a stacked line and column chart in PowerBi Desktop. So far I could display this in excel without any problems, but this does not work in powerbi! I have a table with...
lbendlin
Super User
Super Userhow is that different from the column chart I posted?
Your diagram is exactly right, but it had to be changed. You have made the columns for the years 2024, 2025, 2026, 2027 and 2028 into one column. That works and I understand it.
However, my difficulty is that I get an excel with many rows from which I build the chart. This excel file also changes again and again, so I wanted to make an interface in the future. So I was wondering if it is possible to create a pivot chart in Power Bi so that I can keep the columns as they were originally and still have a separate column in the chart for each year.
Translated with DeepL.com (free version)