How to show table as clustered chart

[Sholay]

Hello all, i will appreciate your help on this. I have a filtered table in excel that shows data from the current week and the previous week. There is also a clustered chart that compares information from the current week with the previous week. I want to replicate same filtering and chart in Power BI. See the screenshot below.

I have not been able to figure out how to display the data as clustered chart in power bi. Please Help. 

[v-shex-msft · Accepted solution]

Hi @Sholay,

I think you can try to use unpivot table function(power query) to convert multiple column to Attr and Value columns. then use new columns to create clustered chart.(Drag 'week ending' to legend field, Attr to axis field, Value to value field)

Regards,

Xiaoxin Sheng

[GilbertQ]

Hi @Sholay

What I would suggest doing is to bring in a Date table, which has all additional columns such as Week Numbers or you can create a column which will have the week ending.

Here is a blog post explaining how to create the Date table and then create the relationship from your current table to the date table.

https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fi...

Once that is done you can then use the Week Number or Week Ending Number to your Clustered Chart Visual. And then put your value or measure to the values field in your Clustered Chart Visual.