Forum Discussion

ghouse_peer's avatar
ghouse_peer
Icon for Post Patron rankPost Patron
4 years ago

Showing data in Line and clustered column chart with table

Hi Team,

I have a requirement where i need to show data in Line and clustered column chart with table below. [Pic for reference]

 

 

I have data in excel file.

TypeMonthStatusCounts
PBI1/1/2022Open126
PBI1/1/2022Closed125
PBI1/1/2022Backlog37
PBI2/1/2022Open468
PBI2/1/2022Closed459
PBI2/1/2022Backlog46
PBI3/1/2022Open535
PBI3/1/2022Closed534
PBI3/1/2022Backlog47
PBI4/1/2022Open49
PBI4/1/2022Closed49
PBI4/1/2022Backlog47
PBI5/1/2022Open126
PBI5/1/2022Closed126
PBI5/1/2022Backlog47
PBI6/1/2022Open197
PBI6/1/2022Closed197
PBI6/1/2022Backlog47
PBI7/1/2022Open1025
PBI7/1/2022Closed1023
PBI7/1/2022Backlog49
PBI8/1/2022Open753
PBI8/1/2022Closed748
PBI8/1/2022Backlog54
PBI9/1/2022Open77
PBI9/1/2022Closed61
PBI9/1/2022Backlog70
Pro1/1/2022Open5007
Pro1/1/2022Closed4997
Pro1/1/2022Backlog62
Pro2/1/2022Open2057
Pro2/1/2022Closed2053
Pro2/1/2022Backlog66
Pro3/1/2022Open4790
Pro3/1/2022Closed4782
Pro3/1/2022Backlog74
Pro4/1/2022Open4406
Pro4/1/2022Closed4395
Pro4/1/2022Backlog85
Pro5/1/2022Open3958
Pro5/1/2022Closed3923
Pro5/1/2022Backlog120
Pro6/1/2022Open4964
Pro6/1/2022Closed4914
Pro6/1/2022Backlog170
Pro7/1/2022Open5011
Pro7/1/2022Closed4930
Pro7/1/2022Backlog251
Pro8/1/2022Open2501
Pro8/1/2022Closed2455
Pro8/1/2022Backlog297
Pro9/1/2022Open831
Pro9/1/2022Closed719
Pro9/1/2022Backlog409
Premium1/1/2022Open13521
Premium1/1/2022Closed10056
Premium1/1/2022Backlog3749
Premium2/1/2022Open4390
Premium2/1/2022Closed3994
Premium2/1/2022Backlog4145
Premium3/1/2022Open2423
Premium3/1/2022Closed2262
Premium3/1/2022Backlog4306
Premium4/1/2022Open2076
Premium4/1/2022Closed1994
Premium4/1/2022Backlog4388
Premium5/1/2022Open4696
Premium5/1/2022Closed4298
Premium5/1/2022Backlog4786
Premium6/1/2022Open5553

 

Requirement: Column "Type" will be taken into Slicer and X- Axis will be months & Open, Closed Counts should be in bars i,e Columns and Backlog should be in line as shown in pic above.

And below the graph we need table showing the same values i,e Months, Open ,Closed, Backlog counts same as shown in the Pic above.

 

I serached in the commuinty for solution and got workaround for this: 

community.powerbi.com/t5/Desktop/Display-a-table-clustered-with-bar-and-line-chart/m-p/1074703#M498596  

 

It wil be hepfull if you guys provide solution for my requirement.

 

Thank you.

 

 

3 Replies