Forum Discussion

Velias's avatar
Velias
Regular Visitor
9 years ago
Solved

Date range on visualization

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?
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Velias's avatar
Velias
Regular Visitor
9 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Velias
      Regular Visitor
      9 years ago

      Thanks Anonymous!

       

      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 :(

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Velias,


        Could you please post sample data with a table ?

        Thanks,
        Lydia Zhang