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 agoFirst 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
2 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?
- Joshhunter2 years agoFrequent Visitor
like here: excel data
- lbendlin2 years ago
Super User
how is that different from the column chart I posted?