Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Stacked Bar Chart with 2-3 Values

Hello everyone,   I would like to have multiple %100 stacked bars showing different "Values"    I have created this visual.        I need to put another value and have a stacked bar in ...
Need Help
Show and Tell
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi, Anonymous 

    You need transform the query related with the table creating visual in Power Query Editor.

     

    1 Use Headers as First Row

     

    2 Transpose

     

    3 Use First Row as Headers

     

    Then use the new table to create visual, the result looks like this:

    Here is the pbix.

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

You need transform the query related with the table creating visual in Power Query Editor.

 

1 Use Headers as First Row

 

2 Transpose

 

3 Use First Row as Headers

 

Then use the new table to create visual, the result looks like this:

Here is the pbix.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.