visualiation problem

[anaorca1990]

hello

i have a column chart which over 200 columns i would like to group all of this colums into one and create average. but also i would like to use a filter so once i filtered it will show like the average in one column and the value i choose in another column

dont know if this is possible, any help will be greatly appreciate!

[Anonymous]

Hi @anaorca1990 ,

Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.😊

You can share your screenshot of them or save your sample files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.

Best Regards,

Yuna

[amitchandak]

@anaorca1990 , I would suggest unpivoting is such a case

https://radacad.com/pivot-and-unpivot-with-power-bi