I have a Dashboard that is populating from a SharePoint List. The visuals for the status' and choice data are great but because there are memo fields in the List, displaying records is brutal. What is the best way to view the full records that include large memo fields? I thought the multi-row card but it doesn't present well. What I really want is a portrat view of each record, similar to a record form in excel.
It essentially presents each record alone with the selected fields presented vertically and autofits the data either next to or below the heading. The scroll bar then navigates one record at a time like flipping through a book.
With such I would be able to click various visuals to filter down to the associated recards and then browse the details of those recards. ReCards.. get it 😉
Solved! Go to Solution.
Thanks Sean, So far as I can tell this is the best solution available at the moment, and it is actually pretty awesome. I would still like to see a visual that allows me to display a single record in portrait view.
To make this work I did have to build some calculated columns to aggregate the text I wanted to present. In exploring this solution I discovered that PowerBI is truncating one of my memo fields from the SharePoint list. Now I am on to the next issue, but I will post a new query.
They are both nice but dont quite get me there, or at least at first try. The grid doesn't wrap text and presents the records one row at a time so that doesn't fit what I am looking for. I will use it elsewhere though. The snippet looks better but it does not interact with the other visuals so those filters don't seem apply.
I will keep playing and see if I can get it to work.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.