cancel
Showing results for 
Search instead for 
Did you mean: 
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

Accepted Solutions
Highlighted
PorterHaus
Frequent Visitor

Re: Filter data but not X Axis

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
Highlighted
PorterHaus
Frequent Visitor

Re: Filter data but not X Axis

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors