Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ?
Solved! Go to Solution.
Go to Edit queries
select "col1" to "col5", then "Unpivot columns"
Close&&Apply, add columns in the visua as below
Best Regards
Maggie
Go to Edit queries
select "col1" to "col5", then "Unpivot columns"
Close&&Apply, add columns in the visua as below
Best Regards
Maggie
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |