Stacked Column chart with values from multiple columns from Same file

[PKPavanK]

Hey,
I am new to this tool. I have queried the data from Azure. The file has 7 columns. I want to visualize that in a way as in attached image. I tried creating custom columns with null values for each of columns and tried to visualize, but didn't work and I think its not the right way. I should be bothered only about counts not the data. I am not able to figure out how do I do it.

[v-ljerr-msft · Accepted solution]

Hi @PKPavanK,

If I understand you correctly, you can firstly use the Upivot Columns option in Query Editor to unpivot the columns that you want to show on the chart, and then create a new column to indicate if the Value is null, then you should be able to show the Attribute column as Axis, new column as Legend, count of new column as Values to get your expected result. 

For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. 

Regards

[PKPavanK]

I have one more question. After visualizing the unpivoted data, I get to see the chart as required. But, if I want to see the row level data it is not possible due to the table being unpivoted. Any iput on how can I go ahead to achieve that?

[PKPavanK]

Thanks!
That helped.