Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
imadelmouden
Frequent Visitor

Show values of a records in bar chart

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

 

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 :
test1.PNG

 

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

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @imadelmouden

Go to Edit queries

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

3.png

4.png

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

5.png

 

 

Best Regards

Maggie

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @imadelmouden

Go to Edit queries

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

3.png

4.png

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

5.png

 

 

Best Regards

Maggie

Thank you @v-juanli-msft

I already did figure it out Smiley Very Happy

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.