Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone!
I'm trying to build a model where I present different kinds of data over time, and I would like to be able to put all kinds of data on the same timeline. First of all, I want to create a stacked column + line graph like below.
Now, I have multiple rows for capacity, which all have different initial capacities. In addition, I have dates when improvements are made (then the capacity is 0 for a while) and then greater than initial capacities.
The need for capacity (line in the graph) comes from a different table.
I tried creating a "master date table", and with a following measure i got it to work - given that i set the source of the capacity (n001, n002,..) as a legend.
if(FIRSTDATE(Capacities[Improvement start date])>FIRSTDATE('Date'[date]),sum(Capacities[Initial capacity]),if(FIRSTDATE(Capacities[Improvement end date])>FIRSTDATE('Date'[date]),0,sum(Capacities[New capacity])))
Of cource, it doesn't work without the legend, because it always checks the first date. However, in the future, I would like to present the type of capacity, not the source of it, so I'll need it fixed. Any ideas how to do it?
Thanks!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |