Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago

Do 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 is empty. If in result it has 500 rows - its shown in the table, all the rows

 

How to achieve that?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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. 

    • Pbiuserr's avatar
      Pbiuserr
      Post Prodigy
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        This DAX should work to create an index not using PQ.

        INDEX = RANKX(ALL('Table'), 'Table'[Column],,ASC)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Pbiuserr,

    Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

    If these also don't help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng