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

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

@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

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

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

@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.
Regular Visitor

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

@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

Thank you, Lydia.

Highlighted
Microsoft

@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

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors