Creating a view depending on the chosen date field input

[Anonymous]

Hi

I'm trying to create a view where I will be able to visualize objects and their leaders depending on the actual month +-N months. Could someone please advise about how it should be done?

The result that I am expecting is something that lookes like this, and I hope to make the text dynamic.

Slicers:

• Date: 1) start date 2) end date (indicates what date should be used for showing the data in the table).
• Input value for N months (so the user decides how many months should the view be for)

Tables:

Example from All Data table:

Key	Creation Date	Object Summary	Leader	Start Date	End Date
ICCIT-57	2021-11-20	Object 1	Ann Smith	2021-12-20	2022-05-10
ICCIT-58	2019-01-18	Object 2	John Seller	2019-01-20	2020-01-01
ICCIT-59	2020-06-15	Object 3	Carin Sampson	2020-08-15	2021-05-20
ICCIT-60	2020-09-20	Object 4	Ann Smith	2020-09-21	2021-09-19
ICCIT-61	2021-01-05	Object 5	John Seller	2021-01-21	2022-08-21
ICCIT-62	2020-02-17	Object 6	Carin Sampson	2020-02-28	2021-04-13
ICCIT-63	2021-02-18	Object 7	Ann Smith	2021-12-18	2022-07-03
ICCIT-64	2022-02-10	Object 8	John Seller	2022-02-15	2023-11-21
ICCIT-65	2019-09-12	Object 9	Carin Sampson	2019-10-12	2019-03-15
ICCIT-66	2019-09-18	Object 10	Josh Wellington	2019-09-25	2019-06-10

Thanks beforehand!

[Anonymous]

Thanks, but this is not exactly what I need. I have managed to solve the main part of the problem, but Im struggling with allowing the user choose what type of date the data should be shown for.

What I did: I have created calculated columns for +1,-1 and current month which serve as filters for the three tables. So I am now able to show 3 tables showing the name of objects & Leader with a end date in current month, +1 month, and -1 month from the current month.

Goal: I would like for user to be able to choose which type of date should the tables visualize - start or end date.

User input: deciding whether Start date or End date should be used

Desired Output:

Table 1 (current month) - shows Project leader and Object and date which have the end/start date in the current month.

Table 2 (plus 1 month)-shows Project leader and Object and date which have the end/start date in the next month.

Table 3 (minus 1 month) - shows Project leader and Object and date which have the end/start date in the previous month.

Is it something that can be done in Power BI, Im still very new to the tool?

[Anonymous]

@Anonymous can you provide the desired look or output you are expecting?

[Anonymous]

Something like this! Hope it makes sense

[v-zhangti]

Hi, @Anonymous 

Please check the following methods to see if they help.

Table:

Date = CALENDAR(MIN('Table'[Start Date]),MAX('Table'[End Date]))

Measure:

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Start Date] ) >= MIN ( 'Date'[Date] )
        && SELECTEDVALUE ( 'Table'[End Date] ) <= MAX ( 'Date'[Date] ),
    1,
    0
)

Put Measure into Filter and set it equal to 1. At this point the view will filter the data within the slicer time range.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.