Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |