Hello,
I am trying to create a time series visual with counts over time, where the x-axis only shows the Year but when you hover over the visual the pop-up shows the Month and Year. I have 2 different data sets I am using, and while I was able to accomplish this for one of the daa sets, replicating the same process for the second data set does not seem to be working. I understand I likely have to use the Date Hierachy within the visual, and I have followed the same process for the time series visual for both data sets yet I am seeing different results.
Both of the data sets have Date columns that include the day of week, day, month, and year. See snippets of the Date column and format settings for each data set below, for reference:
Data set #1:
Data set #2:
I also created a calculated column within each data set called "MonthYear" that gives me the Month and Year, using this formula:
MonthYear = format('DATA SET'[DATE],"mm-yyyy")
The calculated MonthYear columns in both data sets also have the same format settings as their original Date columns (as seen in snippets above).
This is what I want:
And this is how I made this visual:
As you can see, this visual only shows the Year on the x-axis, but shows but Year and Month when I hover over it.
This is the visual that is giving me a problem:
And this is how I made this visual:
As you can see, the second visual does show me both Month and Year when I hover over the visual, but the x-axis also is broken down by Year and Month instead of Year alone. If I remove "Month" from the MonthYear date hierarchy, I face the following issue where the visual only shows the Year when I hover over it (see below snippet).
How can I fix this so I can consistently display my visual as intended? Thank you!!
1 ACCEPTED SOLUTION
Yes, this solved my issue! I can't believe it was so simple. Thank you very much!
