Forum Discussion
Weird power Bi dax issue
Dear experts,
as you can see below , when i plot something in excel, it give me right output, but when i convert the same table to line graph or bargraph, value of the month is shifted backward, as you can see August value is 17,365 but in graphs its showing against september
Note: below is the dax i am using
InboundEOM =
VAR __END_DATE = MAXX(ALLSELECTED('InboundDates(Disconnected)M'), 'InboundDates(Disconnected)M'[End of Month])
VAR __START_DATE = EOMONTH(__END_DATE, -6)
RETURN
CALCULATE (
DISTINCTCOUNT ( RECEIPT_CONTAINER[CONTAINER_ID] ),
FILTER (
RECEIPT_CONTAINER,
RECEIPT_CONTAINER[End of Month] >= __START_DATE && RECEIPT_CONTAINER[End of Month] <= __END_DATE
)
)
looks like when this measure is plotted in graph, its showing weird result
1 Reply
- lbendlin
Super User
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523