Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm new to BI and still learning.
I'm trying to create a custom stacked column chart as below (excel):
This is how i'm planning to collect data:
Please advise a solution.
Thanks in advance!!
Solved! Go to Solution.
For your consideration, it might be easier to collect information in a format such as:
Name | Office | Designation | Task Completion | Task Type |
Person 1 | A | Manager A | 1/1/2023 | Task 1 |
Person 1 | A | Manager A | 2/1/2023 | Task 2 |
But to answer your question for your format, I'd solve it by
* Transform Data
* Select Columns Task1 and Task2
* Unpivot Columns
and then graph.
Here is a visual of the above steps:
what table looks like after:
And then you'll be able to graph like you desire:
Here is the pbix solution (I also added a calendar relation): https://www.dropbox.com/s/1t0irgdb5kbuld0/helping.pbix?dl=0
For your consideration, it might be easier to collect information in a format such as:
Name | Office | Designation | Task Completion | Task Type |
Person 1 | A | Manager A | 1/1/2023 | Task 1 |
Person 1 | A | Manager A | 2/1/2023 | Task 2 |
But to answer your question for your format, I'd solve it by
* Transform Data
* Select Columns Task1 and Task2
* Unpivot Columns
and then graph.
Here is a visual of the above steps:
what table looks like after:
And then you'll be able to graph like you desire:
Here is the pbix solution (I also added a calendar relation): https://www.dropbox.com/s/1t0irgdb5kbuld0/helping.pbix?dl=0
It worked. That unpivot really did the trick. Thanks a lot!!
Thanks for the pbix file too!!