Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Remove dates with no data

There are times when I am creating a report and there will be long times between date 1 and date 2. I would like to be able to not show those dates. I wuold like to keep the columns next to each other to more easily show the trend without the blank spaces. Any help would be appreciated.

Need Help

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago
    Hi Anonymous

    On the X-axis select the option categorical, or select the field on the visual (arrow on the rigtg side of the text) were you choose the summarization type and select the option to hide values without data.

    Regards
    MFelix
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Forgive my being new to power bi, but I cannot find the "Categorical" option you mentioned

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        Hi Anonymous,

         

        What is your x-axis data type, month, full date?

         

        Regards,

        MFelix