Ideas to build a Kanban Board with Power BI

[Jan5698]

Hi,

I started using Power BI a couple of weeks ago and totally fascinated about the great impact to my business productivity. My personal aim is to bring all my monitoring and analytics tools inside Power BI and I temporary looking for an idea to build a kanban board with Power BI for example something like the picture under my post.

I know there are a few different online tools to show me tasks and which give me a drag and drop option for the different tasks. But those aren't allowed inside my organization.

Did anyone have an idea how it could be possible to build a kanban board - only as visualization - perhaps with the base data in excel (there aren’t any other software tools like MS Project inside our organization) with the help of Power BI? For me it would be great to have all my KPIs, analytic-, project- and task management tools inside only one software.

Thx for your help and ideas.

Best,

Jan

[tomasbaima]

I had a very similar need and ended up building a custom Power BI visual that works as a read-only Kanban board directly inside Power BI.

It displays tasks as cards grouped into columns, with configurable headers, styling, labels, tooltips, and conditional formatting. It’s designed to show data from Microsoft Planner but I guess it can be used with any data source.

If anyone is interested, I can share the .pbiviz file. Feel free to contact me and I’ll be happy to help or exchange ideas.

[Jonathan198528]

Hi Tomas Baima, can you share the .pbiviz file with me please?

[tomasbaima]

Here the file: https://drive.google.com/file/d/1IqJrDsmfzpfwmLPZ_39-OhAnsd2e2_Nw/view?usp=sharing

I hope it can help, regards!

[tomasbaima]

I don't know how to attach a file here, please share with me your email and I will send it to you

[MFelix]

Hi @tomasbaima ,

You can use a onedrive, google drive, we transfer or similar link to upload your files.

[tomasbaima]

okay that's right, here the file: https://drive.google.com/file/d/1IqJrDsmfzpfwmLPZ_39-OhAnsd2e2_Nw/view?usp=sharing

I hope it can help, regards!

[AlinaK]

Visualisation is realy great. I just curious, why to implement it in PBI, if we have identical in Jira?
Thansk

[takolota]

Free for any licensed Office365 organizations, this SharePoint & Teams template makes one source of truth for a project log, kanbans, GANTTs, workload trackers, & update notifications:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-...

[Anonymous]

Here's what I could achieve with Power BI and the Card Browser custom visual:

[Anonymous]

Could you please post some content on how you got this to work?  How were you able to get it to organize columns like that? 

[JoeRayment]

How did you get the swimlanes in the card browser visual?

[pade]

If you refere to my picture above, there are no swimlanes in the visual. I created them myself by using separate visuals for each swimlane. That's the problem with this visual, that it does not have swimlanes.

It might look kind of nice with the manual created visual (refering to my picture above), but when you start to use the features if the visual, you will dicover that the visual  (in order to create swimlanes) are to narrow

[pade]

@Anonymous, Kind of the same as mine. Hovering over the cards you will have a tooltip that spans outside the actual card, and that is good. But singel clicking the card to expand the card, the card will only expand inside the actual borders of the card. As you have done the same as me, having thin swimlines of "To Do", "In Progres", etc, the card will not expand that much.

If instead the card browser would support swimlanes, the card would expand over the different swimlanes. Since this wasn't possible, I didn't publish my kanban since the usibility was to low. But adding the swimlane feature, or creating a brand new visual focusing in doing kanban boards, this could be a success. Imaging adding Power App and Power Flow ontop of this...

[pade]

I have built a simple Kanban using the Card Browser visual. Although it laks some capability, it kind of possible. I have listed some feature requests that needs to be added in this post: Feature requests for Card Browser

Moving the cards by dragging and dropping will require some extra features. I have not been thinking of this as a build-in visual features, rather I have been thinking of this as some PowerApp/PowerFlow feature ontop of the visual, but please also make my day and implement this in a Kanban Visual and I will be super happy 🙂

[Shauniekent]

Did you find a solution?

I'm considering building a crude Kanban with matrices/tables but worried the formatting might be less than adequate.

[Shauniekent]

Did you find a solution?

I'm considering building a crude Kanban with matrices/tables but worried the formatting might be less than adequate.

[djnww]

Are you completed not allowed to use any other products ? Even Trello ? It's completely online and doesn't require any IT.

You can push data from Trello to Power BI so that senior management can track your progress.

Cheers,

D

[Anonymous]

Could you share info on how to push data from Trello to Power BI ?

Thanks!!

[MFelix]

HI @Jan5698,

Try the customs visuals (https://app.powerbi.com/visuals/) I think that what you want can be achieved with the Strippets Browser visual.

Regards,

Mfelix