Remove blank x values from the visual after applying filter

[gudiya999]

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?

[Anonymous]

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.

[mahoneypat]

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

Pat

[gudiya999]

Hey Pat,

I just tried it messes up the X axis format completely

I still want to see the years