Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
PorterHaus
Frequent Visitor

Filter data but not X Axis

Currently when I filter by date it filters the X-Axis as well but I would like to keep all of the months for the year and just filter the data instead.

 

 Full year:

 

 

Timeline gets filtered as well:

 

If I filtered back to February then I would expect march and april to be empty but still have the rest of the months.

1 ACCEPTED SOLUTION
PorterHaus
Frequent Visitor

What I did to fix this was I created a new table with only the month name and month number (so I can sort properly) and then I created a relationship between my new table and my DimDate table. Then I replaced my axis with the month name from the new table.

 

New Table:

tbl1.PNG

Created relationship with DimDate table:

rel1.PNG

 

Now it works as expected!

Full year:

tk1.PNG

Filtered:

tk2.PNG

 

Note: I also had to check "Show items with no data" as well as filter out Months that are blank because it created a blank month for some reason.

nodata.PNGnot.PNG

View solution in original post

1 REPLY 1
PorterHaus
Frequent Visitor

What I did to fix this was I created a new table with only the month name and month number (so I can sort properly) and then I created a relationship between my new table and my DimDate table. Then I replaced my axis with the month name from the new table.

 

New Table:

tbl1.PNG

Created relationship with DimDate table:

rel1.PNG

 

Now it works as expected!

Full year:

tk1.PNG

Filtered:

tk2.PNG

 

Note: I also had to check "Show items with no data" as well as filter out Months that are blank because it created a blank month for some reason.

nodata.PNGnot.PNG

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.