Forum Discussion

leanns's avatar
leanns
Icon for Helper I rankHelper I
7 years ago

Relationships and Displaying Data

Hello,    I have two questions, one probably easier than the other. I'm creating a report that involves importing data from a SharePoint List which contains multiple single lines of text and multip...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi leanns ,

1. Many visuals can hold large amount of data, mainly depending on what you want to highlight. If you want the visual  like a table, you can try matrix.

2. Did you try to change the cross filter direction of  relationship from single to both?  On my opinion, I think the data was filterd according to the single direction so that it displayed some data. 

 

If you could post the dummy pbix file, we can try the best to solve it.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

leanns's avatar
leanns
Icon for Helper I rankHelper I
7 years ago

Hello v-xuding-msft ,

 

Thank you for the suggestions. 

 

1. I guess I'm stuck with using a table to showcase each query of information. 

 

2. I believe I did try this and it didn't like it either. But I attached a copy of the file for you to take a look through and try out different solutions. All the data is fake and is imported to the SharePoint List through a PowerApps App that I created which I won't mess with until after I hear back from you. 

 

Thanks for the help!

 

CRM - Copy

  • leanns's avatar
    leanns
    Icon for Helper I rankHelper I
    7 years ago

    Hello v-xuding-msft ,

     

    I was wondering if you had a chance to look at my file and see if you could help me? 

     

    Thanks!