Build a clustered column chart with data from different SharePoint lists

[IvyDong]

Hi all,

I'm requesting your kind help in building a clustered column chart with data from different SharePoint lists. I'm so new to Power Bi so it would be greatly appreciated if you can provide some instructions.

Here is my difficulty in detail:

I have four SharePoint lists tracking different corp actions and I have imported them to the Power Bi desktop successfully, shown as in the image below. Basically, they have the same content (Hazard Hunt, HSE Inspection, and LFI have their respective 'status') and I'd like to use the 'status' especially. (BTW, I've set the 'status' field in SharePoint lists as a multi-option field)

And my dreaming clustered column chart is like this:

I think this could be possible but I totally could not find exact steps. Look forward for some help. Big thanks in advance!

[johnyip]

For the exact steps, please provide a sample pibx file with the same data structure as your genuie data, for people's working.

[IvyDong]

Thanks for the reminder. Plz see the sample file in this url: https://drive.google.com/file/d/1khG8fVVtAZq3j1b8maVF8LWA2-isA652/view?usp=drive_link