Forum Discussion
Tooltip - Different Timeline Query
- 4 years ago
Anonymous , If you are using a tooltip page then you can can avoid passing the time by switch off keep all filters and drag the required filters below it.
Also with time intelligence you should be able to show last year same month or last period same month
using a measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
- 4 years ago
Hi, Anonymous
try to create measures like below:
CurrentYear = var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year]) var _r= IF(HASONEVALUE(Table1[Year]), CALCULATE( SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])), CALCULATE( SUM(Table1[Sale]),'Table1'[Year]=_maxyear)) return _rLastYear = var _maxyear=MAXX(ALLSELECTED(Table1),'Table1'[Year])-1 var _r= IF(HASONEVALUE(Table1[Year]), CALCULATE( SUM(Table1[Sale]),'Table1'[Year]=SELECTEDVALUE(Table1[Year])), CALCULATE( SUM(Table1[Sale]),'Table1'[Year]=_maxyear)) return _rThen create a tooltip page.
Or instead of using the tooltip page, you can use the small multiples feature to display multiple years of data.
Drag and drop the year field into the small multiples bucket.
Select the year you want to display in the filter or slicer.Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , If you are using a tooltip page then you can can avoid passing the time by switch off keep all filters and drag the required filters below it.
Also with time intelligence you should be able to show last year same month or last period same month
using a measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))