Forum Discussion
Single Date Slicer for Multiple Dates on Visual
Anonymous this is what you need to do, which will take care of everything.
Unpivot your table, in query editor, select your school column and right click, and select upivot other columns
It will add two column, one attribute which will be your category and other column value which will be your dates
Apply the changes, add calendar dimension in your model (many blog posts are there).
On bar chart, use date/month/year on x-axis from calendar table, legend will be your attribute and value will be count of rows from your table.
Now you can slicer and dice the data by date or by category.
Impactful IndividualHi,
A good way to do this, would be to remodel your data.
Try modelling your date columns to a single data column.
Example:
| ID | Date | DateType |
| 123 | 08/08/12 | Leaving Date |
| 123 | 09/08/12 | Registered Date |
| 123 | 10/08/12 | Enquire Date |
This way you'll be able to do a (Distinct)Count on ID, use DateType as Legend and Date as Axis.
Let me know if you need any more help