topic Re: RACI Matrix in Custom Visuals Development Discussion

RACI Matrix

Smudgers9 — Mon, 13 Mar 2023 14:42:45 GMT

Has anyone created a RACI Matrix in Power BI? I'm looking at creating something like the below from Excel so this can be a shareable dashboard. Any thoughts?

Re: RACI Matrix

giammariam — Tue, 14 Mar 2023 10:25:47 GMT

Hey @Smudgers9 , you may be able to get close enough with the native power bi matrix visual. Otherwise, this is definitely something that could be done in Deneb.if you are unfamiliar, there will be a bit of a learning curve involved. If you are able to provide a sanitized dataset (here's how), I'd be happy to provide an implementation to show what is possible.

Re: RACI Matrix

Smudgers9 — Tue, 14 Mar 2023 10:52:30 GMT

Thanks for replying @giammariam Attached is a sanitised data set. let me know if you need further clarification on the data. I really appreciate you looking into this for me.https://sanctuary.sharefile.com/d-sd45f2e71907e415c86f8f5247499ea23

Re: RACI Matrix

giammariam — Tue, 14 Mar 2023 15:53:48 GMT

@Smudgers9 how critical is it to be able to expand and collapse sections? If you controlled which systems were visible via slicer, would that be sufficient?

Re: RACI Matrix

Smudgers9 — Tue, 14 Mar 2023 15:56:44 GMT

@giammariam a slicer could work just as nicely to be honest. My only concern is the list of systems could be 100 plus so the slicer becomes very large.

Re: RACI Matrix

giammariam — Wed, 15 Mar 2023 18:45:57 GMT

Hey @Smudgers9. Here's what I was able to come up with using the native matrix visual in Power BI. I generated notional data for this, that's why the "System" and "Sub Categories" are just random characters. To save space and have the column headers rotated 90 degrees, I generated dynamic SVGs with DAX.

The .pbix can be downloaded here.

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further/clarify any questions about the implementation.

Re: RACI Matrix

NadiaK — Mon, 08 Apr 2024 09:33:34 GMT

Hi @giammariam

I would like to rotate my column headers with 90 degree, but using your DAX formular, the output is the code and not the title.
Below an example of my matrix, where I want the 'competence' be vertical-