Forum Discussion
Displaying multiple dates across a single x axis
kenyonca You're correct, I don't think you would be able to use those filters. How about this as another option? What we need to do is unpivot your dates in the Query Editor. I added Location as a column in my sample dataset to use as an example.
In the Query Editor I selected my date columns and clicked Unpivot Columns
The result is this; you can rename "Attribute" and "Value" if you want, but now you have a list of dates that are being described by the attribute.
You can now set up a relationship between your Date table and your single Date column in your table
I can build a bar chart that looks like this:
And filter on location using a Slicer.
Does this meet all your requirements?
Thats a good workaround for that issue thanks danrmcallister. I should maybe have mentioned there is still quite a few different filters that we are trying to run such as Discipline, Location, Work Area, Actual Labor MHRs, etc. This data is all on the same rows as those other dates.
With that when I try to apply those filters they dont make any changes to the data. My guess is this because the "count" function used doesnt take into account any of this information.
kenyonca You're correct, I don't think you would be able to use those filters. How about this as another option? What we need to do is unpivot your dates in the Query Editor. I added Location as a column in my sample dataset to use as an example.
In the Query Editor I selected my date columns and clicked Unpivot Columns
The result is this; you can rename "Attribute" and "Value" if you want, but now you have a list of dates that are being described by the attribute.
You can now set up a relationship between your Date table and your single Date column in your table
I can build a bar chart that looks like this:
And filter on location using a Slicer.
Does this meet all your requirements?