Forum Discussion

Stefan75's avatar
Stefan75
Frequent Visitor
3 years ago
Solved

Customizable X-Axis based on different dates

Hi,  I used this formum in the past quite a lot if I´m struggling at the creation of some dashboards. It´s a great playce to find for the most of the issues a solution or an idear how to solve it. ...
Need Help
Shaurya's avatar
Shaurya
Memorable Member
3 years ago

Hi Stefan75,

 

You can start by creating three measures that calculate the aggregate value based on Date1, Date2 and Date3. Create three inactive relationships between the Date table and Quantity table using 'Date'[Date] with 'Quantity'[Date1] and another two for Date2 and Date3.

 

Get the values for the visual by using CALCULATE with USERELATIONSHIP and then create a measure slicer to choose the Date type selection and put Date from Date table into a slicer to get timeframe selection.

 

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

  • Stefan75's avatar
    Stefan75
    Frequent Visitor
    3 years ago

    Hi Shaurya,

    thanks for you answer.  

    i´m not sure how to create the mentioned relationships because the relevant data is in the same table with the following columns:

    - Sales order

    - Date 1

    - Date 2

    - Date 3

    - Quantity

    - Price