powerbi vs. excel

[Joshhunter]

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 many rows containing clusters. I also have 6 columns, one column with a description and 5 columns for the years 2024, 2025, 2026, 2027 and 2028 containing the turnover.
In excel I was able to build a stacked column and line chart. To do this, I selected the legend = cluster and the 5 columns as horizontal axis labels under "Select data..." in excel. Here I was able to create the data series by cluster. Here, after selecting some clusters, the 5 columns with the years resulted in 5 columns. I was also able to display the remaining clusters as a line.
I cannot do this in PowerBi. There is only one column.

Power BI Desktop Data 
Excel Data 

Can you help me to get this diagram in PowerBi?
Is there a sample file for this?

I am very grateful for your help

Sincerley
Josh

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Joshhunter]

Thank you @lbendlin !
I edited my post. Hopefully it has all information, which will be needed.

[lbendlin]

Second request:  Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[Joshhunter]

Thank you again Ibendlin!

[lbendlin]

First step is to unpivot your data to bring it into usable format.

From

to

Then the visual nearly writes itself. For the capacity you can use a measure, or hard code the value.

[Joshhunter]

Thank you!
It's not possible to make an pivot diagramm in Bi?

[lbendlin]

how would that look like in Excel?

[Joshhunter]

like here: excel data 

[lbendlin]

how is that different from the column chart I posted?

[Joshhunter]

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)