How to split graphs in two halves (15 days each)

0
votes

I want to split graph in two halves of 15 day each using dates

enter image description here

i have tried using Top N filters Top and Bottom but when date range is changed i have duplicated graphs.

enter image description here

Split is happening using above filter but when i reduce date filter range duplicate data is shown in two graphs

enter image description here

i tried Flag = IF(DAY(MAX('Table'[Date]))<=15,1,2) as well but was getting data not in sequential order

not in seq order

I'm new to this any help will be thankful.

powerbidaxpowerquery