Table Visualization Help

[Boldy1]

I'm trying to split a large table visually into two tables. I can't have a scroll bar thus the need to "split" the table. I have seen how I can make one table into two but then the data wouldn't all filter together and that is what I am needing to acheive.

Any help would be appreciated

[Boldy1]

@v-lili6-msft @az38 @parry2k Thank you all for your help so far. I've made a sample file with the information as it is laid out. This is probably a dumb question but I can't seem to figure out how to attach that file so you all can see it

[parry2k]

@Boldy1 you cannot attached file, share it using onedrive or google drive.

[Boldy1]

I understand that's how it is shared but I was asking specifically on this forum. Can I post the file so that anyone trying to help answer can view it and manipulate it to try and solve the question?

Thanks!

[v-lili6-msft]

hi @Boldy1 

You could not attach file in the forum directly, only power bi Community Support Team could do it for now.

You can upload it to OneDrive and post the link here.

Regards,

Lin

[az38]

Hi @Boldy1 

try create a measure like this

FilerField = if(isodd(CALCULATE (
        COUNTROWS ( 'Table' );
        FILTER ( ALLSELECTED (  'Table'  );  'Table'[Column1]  < MAX (  'Table'[Column1] ) )
    )+1);1;2)

it will return you "1" for odd rows, 2 for other. It will work with any applied filters

next, create 2 visuals table.

in first one set visual filter "less than 2"

in the second one - "greater than 1"

enjoy.

but it will work if rows order isnt important

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin

[Boldy1]

This makes sense but I wasn't specific enough in my original question. I have 37 rows and want to have 18 on one side and 19 on the other. The problem is when I split the data I can have any sorting I want to do by column continue across both tables. I'm having to sort both tables individually.

So is there a way to have the rows split in two groups while still being able to sort by column information across all 37 not just in the individual groups?

[v-lili6-msft]

hi @Boldy1 

Sample data and expected output would help tremendously, and we could give you further help.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[parry2k]

@Boldy1 whatever column you are planning to slicer these tables on, create seperate table for those columns and set relation of that new table wiht your split table, and in slicer value from new table, it will allow you to filter both the table