Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All
I am using Timeline visuals for date filter in our graph.
https://app.powerbi.com/visuals/show/Timeline1447991079100
How can I selected different-different year quater in "Timeline". Like "2016 Q1", "2015 Q1"
Or any other vizaulatiozation for it.
Please suggest me.
Regards,
Sandeep
Solved! Go to Solution.
>>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
>>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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |