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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Dedmon, 

 

Thank you very much for your reply to this question.  I was able to create a disconnected table and put date column and the disconnected table in X-Axis and set concatenate labels off.  I am just starting to use Power BI this month, so I am unfamiliar with the Measures feature and how to create a new measure as you outlined (the one I created shown below doesn't seem to work)...

Here is what I created, but I am having trouble tying everything together: 

 

 

*Extended Amount (Base) represents Pipeline, Weighted Pipeline is W-Pipeline, and FY21 Budget is the same.  

 

Can you please share in detail how I can tie everything together?  

 

Thanks again in advance,

Alex