Forum Discussion

gudiya999's avatar
gudiya999
Frequent Visitor
5 years ago

Remove blank x axis from visual after applying filter - selecting category

Hello,

 

Can someone please help me solve this?

 

I have a filter with the following categories

When I select the category "Average" I get this:

 

Goal: Is there a way where I could filter out these blank spots in here and have a continuous graph?

 

Need Help

3 Replies

    • gudiya999's avatar
      gudiya999
      Frequent Visitor
      5 years ago

      Hey Greg, I did try but it messed the x axis format

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        gudiya999 Perhaps try getting rid of the hierarchy in the axis and just using Year, unless you want the drill down to be active.