Forum Discussion
Stacked Column chart with values from multiple columns from Same file
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.
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. :smileyhappy:
Regards
3 Replies
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. :smileyhappy:
Regards
