Forum Discussion
Solved
Line graph 6 months backward based on Dropdown selection
Hi Team, I have created 2 line graphs, which is like last 6 months and 6 weeks view and also a dropdown for interaction with this line graph, see below what i want is when i select the dro...
Hi,
You may refer to my solution in the attached PBI file.
Hope this helps.
pls ignore i manage to find a solution
i created another measure
Inbound =VAR __END_DATE_WEEK =MAXX(ALLSELECTED('Dates(Disconnected)W'),'Dates(Disconnected)W'[End of Week])VAR __END_DATE_MONTH =MAXX(ALLSELECTED('Dates(Disconnected)M'),'Dates(Disconnected)M'[End of Month])RETURNIF(ISFILTERED('Dates(Disconnected)W'[End of Week]),CALCULATE(DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID]),FILTER(RECEIPT_CONTAINER,RECEIPT_CONTAINER[End of Week] = __END_DATE_WEEK)),IF(ISFILTERED('Dates(Disconnected)M'[End of Month]),CALCULATE(DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID]),FILTER(RECEIPT_CONTAINER,RECEIPT_CONTAINER[End of Month] = __END_DATE_MONTH)),DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID])))
hi, are you able to support or share some idea to help?
Otherwise these disconnected tables will not help, it may only help for the line graph, not the visuals on my dashboard
here is my pbix file, i have been looking for solution since last 2 days, any help will be highly appreciated
https://drive.google.com/file/d/1EP3BMNtm3ueuFrl0V9a_S5QB_tDXWas6/view?usp=sharing
pls ignore i manage to find a solution
i created another measure
Inbound =
VAR __END_DATE_WEEK =
MAXX(ALLSELECTED('Dates(Disconnected)W'),'Dates(Disconnected)W'[End of Week])
VAR __END_DATE_MONTH =
MAXX(ALLSELECTED('Dates(Disconnected)M'),'Dates(Disconnected)M'[End of Month])
RETURN
IF(ISFILTERED('Dates(Disconnected)W'[End of Week]),
CALCULATE(
DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID]),
FILTER(
RECEIPT_CONTAINER,
RECEIPT_CONTAINER[End of Week] = __END_DATE_WEEK
)
),
IF(ISFILTERED('Dates(Disconnected)M'[End of Month]),
CALCULATE(
DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID]),
FILTER(
RECEIPT_CONTAINER,
RECEIPT_CONTAINER[End of Month] = __END_DATE_MONTH
)
),
DISTINCTCOUNT(RECEIPT_CONTAINER[CONTAINER_ID])
)
)