Date range on visualization

[Velias]

Greetings! Please tell me how I can add to the visualization tools dashboards date range, as well as the opportunity to compare the two ranges and display the percentage difference?

[Velias]

Greetings! Please tell me how I can add to the visualization tools dashboards date range, as well as the opportunity to compare the two ranges and display the percentage difference?

[v-yuezhe-msft]

Hi @Velias,

Based on your description, it’s difficult for us to provide detailed solution. Could you please share sample data of your scenario and post expected result here?

In addition, if you just need a date range selector to filter data in your report, you can use  the Timeline custom visual.


Thanks,
Lydia Zhang

[Velias]

Thanks @v-yuezhe-msft!

Timeline custom visual - good thing.

To solve their problems I need to compare periods. For example a visit to the site 09.05.2016 - 11.09.2016 compared with 29/08/2016 - 09/04/2016 or 08/09/2016 compared to 04/08/2016. Need a percentage of the difference of the two periods specified manually.

Example: site visits in the period 05.09.2016 - 11.09.2016 up 25 percent of visits to the site 08/29/2016 - 04/09/2016

Sorry for my English 😞

[v-yuezhe-msft]

Hi @Velias,

Could you please post sample data with a table ?

Thanks,
Lydia Zhang

[Velias]

Date	Sessions
05.09.2016	1000
06.09.2016	1500
07.09.2016	1500
08.09.2016	900
09.09.2016	1200
10.09.2016	2000
11.09.2016	2500

for example: 09.09.2016 - 11.09.2016 above 43% than 05.09.2016 - 07.09.2016 etc.

[v-yuezhe-msft · Accepted solution]

Hi @Velias,

You can write the following formulas to calculate percent difference. For mor details, please review the example in the attached PBIX file.

1. Create a measure that calculate sessions between 2016,9,5 and 2016,9,7.
Sessionsum = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

2. Create a measure that calculate sessions difference between two date ranges.
Session difference = CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,9), DATE(2016,9,11)))-CALCULATE(SUM(Table2[Sessions]), DATESBETWEEN(Table2[Date],DATE(2016,9,5), DATE(2016,9,7)))

3. Create a measure that calculate percent difference and format the measure using the following percentage option.
Percent difference = DIVIDE([Session difference],[Sessionsum])

Thanks,
Lydia Zhang