I have 'odd' data in PowerBi.
What I mean is its super wide (243 columns) and it was based on repeated measures in a redcap survey instrument (kinda looks like this:)
You can see the columns (pi_1,cc_1, etc...) come from an instrument that looks like this:
Well I want to display those values in a Power Bi dashboard thats shaped similarly to the original redcap instrument, here's the beginning of my attempt:
My goal is that when you select "May" and "Erin Ryan" like I did in that dashboard, you'd get her results from that page/month as it was displayed in Redcap, like so:
My current strategy isn't working great for several reasons including:
- As far as I can tell the only way to hide headers in a table involve either it being changed to something besides a table and/or making the font color invisible (rather not do that, gotta be a better way)
- The column spacing in each table is different, I know I can turn that off and make it manual spacing, but given the large number of columns I'll be placing (240ish), that sounds like a nightmare.
Is there a better way? A different visual? A better way to group? I know that's vague but I dont know what I dont know.
So to recap/summarize: How can I best display a dashboard that looks similar to what was in Redcap?