Forum Discussion
Show Most recent comments
Hi jcastr02 ,
That is not possible on the table visual as a workaround you can:
- Create a button with no backgroud and no line
- Make the button the size of the column header and place it on top of the header
- Group the table with the header
That way you will still see the header of the table but if you click on it won't be reorder.
Hi,
According to your description, you can not sort the [Value] by [Completion Time] due to existing duplicate values.
You can add an index column, and sort [Index] by [Completion Time], when you choose [Value] in visual, try to add this [index] to the visual as well and [Value] will sort by [Completion Time] because [Index] uniquely corresponds to [Value] in table.
Best Regards,
Giotto Zhi
https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=Mt56rq
I added it to my visual, but still keeps it in alphabetical order. I've attached my BI file as well. Please see 'duplicate of 60 day tab'
trying to work on visual with green background.
https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=Mt56rq
v-gizhi-msft smpa01 Tried both of your solutions but can't seem to have it sort by completion time.
Hi jcastr02 ,
Best option is what you have done in your visualization so placing the comment and index on your table then turn off wrap text on title and sort the table by index then just hide the index column by reducing it's size.
A workaround but it works.
MFelix Yes ! this seems to work! I appreciate the help. Only thing I noticed that repeating items such as N/A, pay, the hours, etc. are pushed to the top so everything else sorts except the repeating items, any work around you are aware of?
Hi jcastr02 ,
Make the summarization of the index column the miminum value and then sort it out. what is happening is that the default behavior of ID is to sum values since you have more than one values for certain comments they get to different positions based on its sum.
If you select minimum you will get the first value of the index.
for example NA in your table is giving the 299 (sum of several index) making it to minimum it gives 17 if you go to your table the first record with NA is line 18 at 17/01/2020 so the first one as you want.