Forum Discussion
Dynamic histogram?
Hello!
Could you help me, please.
I have a table with field adr_id and two dates - date_start and date_end.
I want to show slicer to set the range of dates , and show a histogram with two bins - count records in range of dates, and count records NOT in range of dates...
it very simply with static data, we should just create calculated fields....
But I absolutely lost how to do it in dynamic...
Okay, I may create a table filled with dates (CALENDAR), make a slicer with this table, but - what next?
Calculated fields are not calculated dynamically as I see...
Measure? I think solution is very simple but can't find it )
Any ideas, friends?
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
7 Replies
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,
LydiaThank 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
