multiple columns in one chart

[SebastianAlmer]

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]

@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-q2YBhh...

But I have in the original file about 50 columns in several files. Would take me weeks to do this manually.

[amitchandak · Accepted solution]

@SebastianAlmer , I think you need unpivot multiple times 

refer : https://kohera.be/power-bi/how-to-unpivot-twice/

[SebastianAlmer]

Nailed it.

I can't believe I didn't think of this myself.... 😂 🙈🙈

[SebastianAlmer]

@amitchandak 

There you are 🙂

PowerBI Sample File to Download

https://almerprojekte-my.sharepoint.com/:u:/g/personal/sebastian_almer_de/EVop-O-sHOdNpae7ZfkdA8YBaK...

[amitchandak]

@SebastianAlmer , 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]

@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.