Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I hope anybody can help me. I have a table with several demands. In the table I have the columns 'closed timestamp', 'demand phase', and 7 columns for the duration in days for every demand phase.
In the end I'd like to have this chart but with all seven demand phases (for better overview I used here just three) and the month should be displayed in different colors and the demand phase should be represented by the x-axis. In short words: I'd like to switch the x-axis and the legend. Unfortunatly PowerBi only let's me set the 'closed tiemstemp' as legend if I use just one value and not all seven.
Any ideas how to solve this problem?
Thank you so much!
Br, Tom
Solved! Go to Solution.
Hi @muelleto,
Please select the demand phases to the axis level, month as legend level, the "average of demand phases" as value level. As the following screenshot shown, please click Data colors(highlighted in red line) under formut button.
If you have any issue, please feel free to ask.
Best Regards,
Angelia
The values are the averages of every demand phase. So average of approval phase, avergae of collection phase, average of qualify phase, average of...
So yeah it's possible to get the demand phases to the axis level but then I'm not able anymore to set the color saturation for the months. I somehow need to bring all the average values of all the demand phase duration colums into one.
Hi @muelleto,
Please select the demand phases to the axis level, month as legend level, the "average of demand phases" as value level. As the following screenshot shown, please click Data colors(highlighted in red line) under formut button.
If you have any issue, please feel free to ask.
Best Regards,
Angelia
@v-huizhn-msft Thanks for your input but this unfortunatly doesnt solve my problem.
What I'd like to get in the end should look like this. The diffrent colors represent the diffrent months. Any ideas how to solve this maybe with a little bit powerquery magic? 😄
Thanks again for any ideas 🙂
Br, Tom
Hi @muelleto,
What's the mean of the value of histogram? Can't you put the date as legend level, the Demand Phase as Axis level?
Best Regards,
Angelia
Sorry I can't share the data but a row looks like this
DemandId | Demand Phase | closed timestamp | Collection Phase Duration in days | Approval Phase Duration in days | Qualify Phase Duration in days |
123456 | Approval | 22.08.2016 | 12.3 | 5.7 | 47.3 |
654321 | Qualify | 24.07.2016 | 10.5 | 7.5 | 10.5 |
Hi @muelleto,
In a clustered column chart, there is only one Axis level. When you select several fields as Axis level, it will drill down according the order you put. It will jump to a new chart when you click the highlighted button like the picture below.
While, we can't put multiple fields as Legend level, we only can put one. Because it can’t determine which group of series need to be “clustered”.
If this doesn't resolve your issue, please post the detail expected result based on your given data.
Best Regards,
Angelia
Would be helpful if you could provide sample data or pbi file.
Regards.
Pavel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |