Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Yes unfortunately PBI at least up till now has been pretty much exclusively about visualizing aggregated and summarized data!
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.
Thanks again,
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.
Yes unfortunately PBI at least up till now has been pretty much exclusively about visualizing aggregated and summarized data!
Thanks Sean, I will check them out and let you know.