Forum Discussion
Helper IIIData Limits on Fields
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,
Lydia
New2PowerBIThanks! 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- New2PowerBI
I can't share all that I have; I can tell you that one value is 1,840 characters in length, with all spaces, and 45 lines of text. Is there a limit of just how much data can be joined and/or how much data is displayed in visuals?