Forum Discussion
Data Limits on Fields
I'm using the Attribute Slicer and joined a few columns together to be able to search for information. Appears to work great; however, when I hover over the information it appears the column value that I see is cut off. It is all there in Query Editor view, but not when I am in the report and dashboard views. Can I change that? Also, how do I know if my Attribute Slicer is working? Does it go off the text in the Query Editor or does it go off of the table view? I'm afraid it will not pull up all results if it's only looking a certain number of characters.
4 Replies
I make a test using AttributeSllicer, long text will be cut off when you hover over the information.
In the sample PBIX file of AttributeSllicer, it notes that we’d better add a categorical filed that is not a long string into Items section of the slicer. This makes sense in terms of performance.
In addition, create a measure in your table to calculate the distinct count number of the field you drag into Items section of the slicer.
CountNumber = DISTINCTCOUNT(Table[columnname])
Then create a Card visual using this measure. And drag the field and the measure into AttributeSllicer, then convert AttributeSllicer to table visual, check if the total value in the table visual matches that value in Card visual. If they match, AttributeSllicer pulls up all values of the field in your table.
Regards,
LydiaThanks! I followed the steps you noted and the card and table matched. I thought it worked and test a handful of examples successfully against the end user screen/data.
I don't think it's working for some of the longer ones, there has to be some form of limit out there. I have one value that is 1840 characters with spaces, 45 lines, and it did not pull up on the listing of the Attribute Slicer when I entered text from the later part of what I was looking for.
Would be easiest to know characters limits, not just on when you view them, but how the attribute slicer pulls/searches for data in any given field.
Could you please share sample data of the longer ones for me to reproduce? It is appreciated that if you can post screenshot about your scenario.
Regards,
Lydia
