Create a stacked column chart with 1 column of 0/1 data

[abhishekahuja]

Hi All,

My dataset looks something like this:

Column1	Column2	Column3
0	1	0
0	1	1
1	0

I want to create a stacked bar chart which had 3 different colors with counts number of 0, 1, and MissingData. Any recommendation will be helpful.

Thanks in advance for your help,

Abhishek

[abhishekahuja]

@amitchandak your feedback was very helpful, thanks for your time and solution.

[amitchandak · Accepted solution]

@abhishekahuja , First in Power Query Change Data Type to Text, Replace value in All column (Select mutiple columns) and use replace 

null

"No Data"

Then unpivot the data 

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

and then you can create stacked  visual