Forum Discussion
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.
| Type | Month | Status | Counts |
| PBI | 1/1/2022 | Open | 126 |
| PBI | 1/1/2022 | Closed | 125 |
| PBI | 1/1/2022 | Backlog | 37 |
| PBI | 2/1/2022 | Open | 468 |
| PBI | 2/1/2022 | Closed | 459 |
| PBI | 2/1/2022 | Backlog | 46 |
| PBI | 3/1/2022 | Open | 535 |
| PBI | 3/1/2022 | Closed | 534 |
| PBI | 3/1/2022 | Backlog | 47 |
| PBI | 4/1/2022 | Open | 49 |
| PBI | 4/1/2022 | Closed | 49 |
| PBI | 4/1/2022 | Backlog | 47 |
| PBI | 5/1/2022 | Open | 126 |
| PBI | 5/1/2022 | Closed | 126 |
| PBI | 5/1/2022 | Backlog | 47 |
| PBI | 6/1/2022 | Open | 197 |
| PBI | 6/1/2022 | Closed | 197 |
| PBI | 6/1/2022 | Backlog | 47 |
| PBI | 7/1/2022 | Open | 1025 |
| PBI | 7/1/2022 | Closed | 1023 |
| PBI | 7/1/2022 | Backlog | 49 |
| PBI | 8/1/2022 | Open | 753 |
| PBI | 8/1/2022 | Closed | 748 |
| PBI | 8/1/2022 | Backlog | 54 |
| PBI | 9/1/2022 | Open | 77 |
| PBI | 9/1/2022 | Closed | 61 |
| PBI | 9/1/2022 | Backlog | 70 |
| Pro | 1/1/2022 | Open | 5007 |
| Pro | 1/1/2022 | Closed | 4997 |
| Pro | 1/1/2022 | Backlog | 62 |
| Pro | 2/1/2022 | Open | 2057 |
| Pro | 2/1/2022 | Closed | 2053 |
| Pro | 2/1/2022 | Backlog | 66 |
| Pro | 3/1/2022 | Open | 4790 |
| Pro | 3/1/2022 | Closed | 4782 |
| Pro | 3/1/2022 | Backlog | 74 |
| Pro | 4/1/2022 | Open | 4406 |
| Pro | 4/1/2022 | Closed | 4395 |
| Pro | 4/1/2022 | Backlog | 85 |
| Pro | 5/1/2022 | Open | 3958 |
| Pro | 5/1/2022 | Closed | 3923 |
| Pro | 5/1/2022 | Backlog | 120 |
| Pro | 6/1/2022 | Open | 4964 |
| Pro | 6/1/2022 | Closed | 4914 |
| Pro | 6/1/2022 | Backlog | 170 |
| Pro | 7/1/2022 | Open | 5011 |
| Pro | 7/1/2022 | Closed | 4930 |
| Pro | 7/1/2022 | Backlog | 251 |
| Pro | 8/1/2022 | Open | 2501 |
| Pro | 8/1/2022 | Closed | 2455 |
| Pro | 8/1/2022 | Backlog | 297 |
| Pro | 9/1/2022 | Open | 831 |
| Pro | 9/1/2022 | Closed | 719 |
| Pro | 9/1/2022 | Backlog | 409 |
| Premium | 1/1/2022 | Open | 13521 |
| Premium | 1/1/2022 | Closed | 10056 |
| Premium | 1/1/2022 | Backlog | 3749 |
| Premium | 2/1/2022 | Open | 4390 |
| Premium | 2/1/2022 | Closed | 3994 |
| Premium | 2/1/2022 | Backlog | 4145 |
| Premium | 3/1/2022 | Open | 2423 |
| Premium | 3/1/2022 | Closed | 2262 |
| Premium | 3/1/2022 | Backlog | 4306 |
| Premium | 4/1/2022 | Open | 2076 |
| Premium | 4/1/2022 | Closed | 1994 |
| Premium | 4/1/2022 | Backlog | 4388 |
| Premium | 5/1/2022 | Open | 4696 |
| Premium | 5/1/2022 | Closed | 4298 |
| Premium | 5/1/2022 | Backlog | 4786 |
| Premium | 6/1/2022 | Open | 5553 |
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:
It wil be hepfull if you guys provide solution for my requirement.
Thank you.
3 Replies
- amitchandak
Super User
There is a custom visual , if that can work for you
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview
- ghouse_peer
Post Patron
amitchandak Thanks for the info, i have seen this visual i dont think so this will be helpfull. But no problem you can Send the steps for creation and showing data into this visual and even for the one which i had mentioned the link for that too steps for creation. Please
- ghouse_peer
Post Patron
Hi Team amitchandak PLease provide the steps to show the trend in above mentioned custom visual( https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview)with the data provided by me. It will be helpfull.
Thanks