Forum Discussion

PKPavanK's avatar
PKPavanK
Regular Visitor
8 years ago
Solved

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 e...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

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

PKPavanK's avatar
PKPavanK
Regular Visitor
8 years ago

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?