Table formatting issues

[harshadrokade]

HI All,

I have created a table visual where I have added three column values as below & have filter on Student name.

I have sorted the table with Header 1 however sometimes its also possible that some Student willl have Header 1 blank, in that case the table will look like below

How to do settings such that the table will show filled values first for all columns & the blanks will be shown at bottom for every column

[harshadrokade]

@jaideepnema Hi Sir, In your file, In Header 2 & 3, I can see some blank rows coming in between. how to fix this so that we get continous values & blank rows get shifted to the end of the table.

[V-lianl-msft]

Hi @harshadrokade ,

When you sort Header1, other corresponding fields will also be sorted synchronously.

There is a relationship between the fields of the table visual . You cannot change the internal relationship of the data.

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

[jaideepnema]

Hi @harshadrokade ,
Press the shift key and select all the three columns twice in order to sort all the three columns in descending order. This will give you the required output.

Refer the attached PBIX for reference.

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

[harshadrokade]

@jaideepnema Thanks sir I didnt get exactly how to do this. Can you pls explain it little bit. Thanks