Forum Discussion

gudiya999's avatar
gudiya999
Frequent Visitor
5 years ago

Remove blank x values from the visual after applying filter

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

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    You could try changing your x axis from continuous to categorical.

    Pat

     

    • gudiya999's avatar
      gudiya999
      Frequent Visitor
      5 years ago

      Hey Pat,

      I just tried it messes up the X axis format completely

      I still want to see the years

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi gudiya999 ,

     

    Please try to turn off "Concatenate labels" option.

    If it does not make sense, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.