Forum Discussion
Joshhunter
2 years agoFrequent Visitor
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
2 years agoSecond 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
2 years agoFrequent Visitor
Thank you again Ibendlin!
- lbendlin2 years ago
Super User
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.
- Joshhunter2 years agoFrequent Visitor
Thank you!
It's not possible to make an pivot diagramm in Bi?- lbendlin2 years ago
Super User
how would that look like in Excel?