Forum Discussion

IvyDong's avatar
IvyDong
New Member
3 years ago

Build a clustered column chart with data from different SharePoint lists

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!