adobe analytics connector - How to get a DATE picker/selector in the canvas to build a dashboard?

[Anonymous]

Hi community,

I'm totally new in using Power BI, and especially leveraging the Adobe Analytics connector. Therefore, apologies in advance for the ridiculous question I'm going to ask here, but I cannot find any document online (from blog, forum, tutorials...) to answer my question.
I want to build up a simple dashboard to visualize Audience, Behavioral and performance siteCentric KPIs.

I already pulled the data sets I need, among which all date granularity levels and other dimensions with metrics, see below screenshot:

I know how to set visualization widgets, but I would like to first of all start by adding up a Date selector, that is obviously essential when we talk about automatic dashboards :). 

How to create a date picker / date selector in power BI? it seems there is no native widgets to do so, hence do I have to create sort of formulas, filters?
It should be the easiest thing in the world but I'm pulling out my har on this.

Thanks a lot in advance for your help!!

Best

victor

[Anonymous]

Hi,

Download the file @ https://1drv.ms/u/s!AtDlC2rep7a-jkiRG_LyHcv0RSXI

Thanks

GrayMatter

[v-lili6-msft]

hi, @Anonymous

It seems that the date column is divided into three columns( year, month, day).

Then you could create a calculate column like this

Date = DATE('Table'[Datelevel1: year],'Table'[Datelevel2: month],'Table'[Datelevel3: day] )

Then drag this field into slicer.

Best Regards,

Lin

[Anonymous]

Thanks a lot @v-lili6-msft, it works ! Now i have an other problem, when i move my slicer my data isn't reloaded. hence, I think the issue comes from my Query notably for the Start date and End date.

I found some post in the forum that give some functions, but when I try, i get and error. 

I want my report to show dynamically the date for the last 30 days (classic for digital dashboards):

If I try:

 {Cube.ApplyParameter, "DateRange", {DateTime.Date(DateTime.LocalNow()-30), Date.From(DateTime.LocalNow())}},

I get:

 "Expression.Error: We cannot apply operator - to types DateTime and Number.
Details:
Operator=-
Left=12/4/2018 7:11:33 PM
Right=30"

Then if I try:

       {Cube.ApplyParameter, "DateRange", {Date.From(DateTime.LocalNow()-30), Date.From(DateTime.LocalNow())}},

I get:

"Expression.Error: We cannot apply operator - to types DateTime and Number.
Details:
Operator=-
Left=12/4/2018 7:11:33 PM
Right=30"

Where is my error?

thanks a lot again!!

best

victor

[v-lili6-msft]

hi, @Anonymous

when i move my slicer my data isn't reloaded. 

When you change data in Slicer, slicer is just a visual, it works on your report, not the data model. 

If you want to reload your data, it should use Parameters in Power BI.

This is the tutorial for you to refer to

reference:https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

and for show dynamically the date for the last 30 days 

You could add a calculate column to judge is this row date is last 30 days like 

filter = IF(DATEDIFF(Table1[Date],TODAY(),DAY)<=30,"last 30 days","not")

then drag this field into report level filter set filter is "last 30 days"

Best Regards,
Lin