Forum Discussion
Pbiuserr
Post Prodigy
4 years agoDo not display visual below certain amount
Hello, I would like to create a table which would not be displayed below certain amount of lines (lets say 20). So if user slice and dice the table and in result, it would have 15 rows - the table i...
Anonymous
4 years agoNot applicable
If I understand correctly, you could add an index starting at 1. Then add a filter to the table or page that says display if Index >= 20.
- Pbiuserr4 years ago
Post Prodigy
Can you tell me how to add an index to the column (not in PQ but report layer) ? This is descriptive table like ID, age, sex etc
- Anonymous4 years agoNot applicable
This DAX should work to create an index not using PQ.
INDEX = RANKX(ALL('Table'), 'Table'[Column],,ASC)