Forum Discussion
Dynamic histogram?
Create the following measures in your table. Please note that there is no relationship between your table and calendar table.
mindate = MIN('Date'[DateKey])
Maxdate = MAX('Date'[DateKey])countinrange = CALCULATE(COUNTA(Table[adr_id]),FILTER(Table,Table[date_start]>=[mindate]&&Table[date_end]<=[Maxdate]))
countnotinrange = CALCULATE(COUNTA(Table[adr_id]),FILTER(Table,Table[date_start]<=[mindate]||Table[date_end]>=[Maxdate]))
Regards,
Lydiafedorez，
You can create one chart to display the measures, see the example below.
Regards,
Lydia
Create the following measures in your table. Please note that there is no relationship between your table and calendar table.
mindate = MIN('Date'[DateKey])
Maxdate = MAX('Date'[DateKey])
countinrange = CALCULATE(COUNTA(Table[adr_id]),FILTER(Table,Table[date_start]>=[mindate]&&Table[date_end]<=[Maxdate]))
countnotinrange = CALCULATE(COUNTA(Table[adr_id]),FILTER(Table,Table[date_start]<=[mindate]||Table[date_end]>=[Maxdate]))
Regards,
Lydia
Thank you for your answer, Anonymous
In your example, countinrange and countnotinrange - two charts... Is where the way to see this bins in one chart? The reason is scale. When we are using Auto scale mode for Y-axis, we have different scales for out two charts. Course, we can set min and max for Y-axis manually in design mode, but we don't know the limits for Y in real life.... it's a problem
Regards,
Denis
fedorez，
You can create one chart to display the measures, see the example below.
Regards,
Lydia