Forum Discussion
Helper IUnable to re-create bar chart within Power BI
Dear community,
I dispair of rebuilding a bar chart within Power Bi that was initially built within Excel and would highly appreciate your kind support.
Here is the bar chart I try to rebuild:
The data source contains four different columns that hold the different answers (52 per column) as text (Strongly agree, agree, etc.). They look like the following. The individual statements can be found at the end of the texts):
I used a Power BI bar chart and tried every possible combination for the x/y axis and legend. I was able to get it done for one column:
However, when I add additional columns, it either doesn't allow me to add more data (what I actually need), or it ends up like this:
Can you please kindly let me know what I'm doing wrong and how I can rebuild the graph within Power BI?
Thank you very much in advance.
Mathias
Hi,
Select all columns other than the 4 columns you alluded to. Right click and select "Unpivot Other Columns". Rename the Attribute and value columns. Now create your visual.
Hope this helps.
3 Replies
- Ashish_Mathur
Super User
Hi,
Select all columns other than the 4 columns you alluded to. Right click and select "Unpivot Other Columns". Rename the Attribute and value columns. Now create your visual.
Hope this helps.
- Mathze03
Dear Ashish,
Please excuse my delay in response. I did it exactly as you said, and it worked! Thank you so much!!!
Greetings from Germany,
Mathias
- lbendlin
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
