Customizable X-Axis based on different dates

[Stefan75]

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.

This is my first post and I hope you can help me.

I have on a dashboard a bar diagram which shows in the Y-Axis a calculated value or quantity. The X-Axis is based on a date value. Now i try to implement a solution to show the value / quantity based on a date which was seleced by an user.

The user shoud select if he wants to show the values aggregates based on Date1, Date 2, etc. and for wich time frame teh bar diagram should show the data

this is an example of the table with the data!

Sales order	Date 1	Date 2	Date 3	Quantity	Price
A	01.01.2022	01.05.2022	01.09.2022	1	10
B	01.02.2022	01.06.2022	01.10.2022	2	20
C	01.03.2022	01.07.2022	01.11.2022	3	30
D	01.04.2022	01.08.2022	01.12.2022	4	40

Thansk a lot for your help.

[Shaurya]

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]

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

[Shaurya · Accepted solution]

Hi @Stefan75,

For your reference:

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts