Forum Discussion

PorterHaus's avatar
PorterHaus
Frequent Visitor
8 years ago
Solved

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...
Need Help
  • PorterHaus's avatar
    PorterHaus
    8 years ago

    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:

    Created relationship with DimDate table:

     

    Now it works as expected!

    Full year:

    Filtered:

     

    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.

PorterHaus's avatar
PorterHaus
Frequent Visitor
8 years ago

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:

Created relationship with DimDate table:

 

Now it works as expected!

Full year:

Filtered:

 

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.