Forum Discussion
Custom Visual Timeline
- 9 years ago
Hi devssolution
>>How can I selected different-different year quater in "Timeline". Like "2016 Q1", "2015 Q1".
We are not able to select the different-different year quarter in custom visual Timeline. We only be able to select continuous date period in Timeline.
For your requirement, you can use visual slicer to get the result as follows.
You’d create a calculate column including Year and Quarter. Then you can display it using the standard List in slicer. I try to reproduce it using the sample date.I create a column Year-Quarter using the formula below.
Year-Quarter = CONCATENATE(YEAR(Sales[Date]),CONCATENATE("Q",ROUNDUP(MONTH([Date])/3,0)))Then I create a slicer and add the Year-Quarter as field. There is relationship between the slicer and report. You can click multiple slicer’s values if you want selected different-different year quarter. For example, please choose 2015Q1 and 2016Q1 simultaneously like the following screenshot. The report will be changed according to the filter.
If you have any question, please feel free to ask.
Best Regards,
Angelia
Hi devssolution
>>How can I selected different-different year quater in "Timeline". Like "2016 Q1", "2015 Q1".
We are not able to select the different-different year quarter in custom visual Timeline. We only be able to select continuous date period in Timeline.
For your requirement, you can use visual slicer to get the result as follows.
You’d create a calculate column including Year and Quarter. Then you can display it using the standard List in slicer. I try to reproduce it using the sample date.
I create a column Year-Quarter using the formula below.
Year-Quarter = CONCATENATE(YEAR(Sales[Date]),CONCATENATE("Q",ROUNDUP(MONTH([Date])/3,0)))
Then I create a slicer and add the Year-Quarter as field. There is relationship between the slicer and report. You can click multiple slicer’s values if you want selected different-different year quarter. For example, please choose 2015Q1 and 2016Q1 simultaneously like the following screenshot. The report will be changed according to the filter.
If you have any question, please feel free to ask.
Best Regards,
Angelia