cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Dynamic histogram?

Hello!

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft

## Re: 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])

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft

## Re: Dynamic histogram?

@fedorez

You can create one chart to display the measures, see the example below.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 REPLIES 7
Highlighted
Microsoft

## Re: 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])

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: Dynamic histogram?

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

Highlighted
Microsoft

## Re: Dynamic histogram?

@fedorez

You can create one chart to display the measures, see the example below.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: Dynamic histogram?

Thanks a lot!

And one last impotent question.

May I do the same in case of Calculated table , when my Table based on some more tables?

Like this:

Table = GROUPBY(Table2;[name];"days_average";AVERAGEX(CURRENTGROUP();[period]))

Highlighted
Microsoft

## Re: Dynamic histogram?

@fedorez,

Yes, you can.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: Dynamic histogram?

Thank you, Lydia.

Highlighted
Microsoft

## Re: Dynamic histogram?

@fedorez,

If you solve your issue, please accept my replies as answer, that way, other community members could easily find the answer when they get same issues.

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors