Stacked Column Chart Showing Count of "Yes" and "No" for Each Item

[Febin]

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!!

[Anonymous · Accepted 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:

select two tasks and unpivot

what table looks like after:

what table looks like after

And then you'll be able to graph like you desire:

pbi output

Here is the pbix solution (I also added a calendar relation): https://www.dropbox.com/s/1t0irgdb5kbuld0/helping.pbix?dl=0 

[Febin]

It worked. That unpivot really did the trick. Thanks a lot!! 

Thanks for the pbix file too!!