Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Stacked Column Chart with 2-3 Values

Hello,   I created the following stacked column charts in Excel using Pivot Tables and need to find a way to build the same/similar charts using Power BI in a stacked format.  Here are screenshots ...
Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Yes, it is possible.  you can create a disconnected table:

     

    Then you can put date column and it in Axis and set concatenate labels off:

     

    Create a new measure by SWITCH  for values like:

     

     

    Measure = SWITCH(SELECTEDVALUE('Table'[Column1]),"Pipleline",.......,"W-Pipleline",......,"FY21 Budget",.......)

     

     

    For more details,  please refer to the similar post: https://community.powerbi.com/t5/Desktop/Stacked-bar-chart-help-to-use-multiple-values/td-p/986028

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

     

     

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Yes, it is possible.  you can create a disconnected table:

 

Then you can put date column and it in Axis and set concatenate labels off:

 

Create a new measure by SWITCH  for values like:

 

 

Measure = SWITCH(SELECTEDVALUE('Table'[Column1]),"Pipleline",.......,"W-Pipleline",......,"FY21 Budget",.......)

 

 

For more details,  please refer to the similar post: https://community.powerbi.com/t5/Desktop/Stacked-bar-chart-help-to-use-multiple-values/td-p/986028

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai