Show values of a records in bar chart

[imadelmouden]

I have this table that will contain 53 records each year ( It's an aggregated table from multiple other tables)

The thing is, I want to show every line in a bar chart, that means, for the line 1 (week 14-18), I must plot the colum1 to colum 5 in same bar (with different colors of course), then the line 2 (week 19-18)....
When I try to do this, it shows me the bars grouped by week, but instead of showinf records values, it count the lines and give me number 3 for the 3 bars like this :

Is their anyway that allows me to show line values instead of summing or counting all lines ?

[v-juanli-msft · Accepted solution]

Hi @imadelmouden

Go to Edit queries

select  "col1" to "col5", then "Unpivot columns"

Close&&Apply, add columns in the visua as below

Best Regards

Maggie

[imadelmouden]

Thank you @v-juanli-msft

I already did figure it out