Forum Discussion
multiple columns in one chart
Hi,
this might be an absolute n00b question, but I can't figure out how to do it.
I have a table with several columns (four in this example). Each columns has a name and several hunders values. I wan't to have the average value per column displayed in one bar chart and want to have the name of the column not via color legend, but displayed either in the bar or left on the side.
How can I achieve this? Do I need to create a calculated table? If so? How?
Original:
Option 1
Option 2
Both Options would be fine for me.
Thanks in advance for your help!
Regards
Sebastian
SebastianAlmer , I think you need unpivot multiple times
6 Replies
SebastianAlmer ,The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.amitchandak
There you are 🙂
PowerBI Sample File to Download
https://almerprojekte-my.sharepoint.com/:u:/g/personal/sebastian_almer_de/EVop-O-sHOdNpae7ZfkdA8YBaKRxE5rTwJjb59VoB_Jfbg?e=IsDwHfSebastianAlmer , While I still doubt, What is the expected output. Based on what I got, I created a solution.
Check the file attached after signature
amitchandak
Thanks for your support. The result should look like:
I've created a new table manualle with:Table3 = { ("Col_A2",AVERAGE(Table1[Col_A1])), ("Col_B2",AVERAGE(Table1[Col_B2])), ("Col_C2",AVERAGE(Table1[Col_C2])), ("Col_D2",AVERAGE(Table1[Col_D2])), ("Col_E2",AVERAGE(Table1[Col_E2])) }
Heres the PBIX:
https://almerprojekte-my.sharepoint.com/:u:/g/personal/sebastian_almer_de/EXugyWZgiVRPrjc92hA-q2YBhhYVkTa4MvHH-vlJ03f_6g?e=R4x5eHBut I have in the original file about 50 columns in several files. Would take me weeks to do this manually.
SebastianAlmer , I think you need unpivot multiple times
Nailed it.
I can't believe I didn't think of this myself.... 😂 🙈🙈
