cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Hi @MFelix,

 

I've followed what you've said and understand it, but am still not getting the right data.  What fields are in the axis and values properties of your line chart?

Highlighted
Super User III
Super User III

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Hi @mhambalek,

 

Axis - Date - Calendar table (hierachy - month)

Values - Measures created for open / close (made with userrelationship)

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

That's what I have and nothing gets graphed in the chart.  I can't choose the hierarchy for the Date field in the Axis.  So it must be how my calendar table is setup.

 

Image 2.jpg

Highlighted
Super User III
Super User III

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Do you have the relatoonship between the tables?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

I deleted the relationships and recreated them.  Both are bidirectional.  I don't know why the from and to are switched between the two.

 

Image 4.jpg

Highlighted
Super User III
Super User III

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Hi @mhambalek,

 

Confirm if all your columns are formatted as date, In my tests I can't replicate the same error.

 

Is it possible to have a sample of your pbix file?

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

I can't share the pbix because of the data that's in it.  I suppose I could save a copy and strip out the sensitive data.

 

Here's what I've noticed:

 

- All three fields (Calendar Date, Create_Date, Date_Closed) are formatted as the same Date type

- The Create_Date line in the chart reports the correct data, but Date_Closed does not.  The data points in the chart doesn't reflect what is in the table.

- The Create_Date allows me to select a hierarchy if I put it into the Axis propertly, but the Calendar Date and Date_Closed does not.  Why wouldn't Calendar Date have a hierarchy when I put it into the Axis property?

- The default relationship for the Create_Date and Date_Closed were different (see screenshot above).  What should they be?

 

Thanks again for your time.

Highlighted
Super User III
Super User III

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Hi @mhambalek,

 

Taking into account that I don't have the file you can try and check if on both relations you have one (calendar table) to many (Support incident) relation if not force them in this way so you would have

 

Calendar Date - Create Date

Type: One - Many

 

Calendar Date - Closed Date

Type: One - Many

 

Regards,

Mfelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog:

Power BI em Português





Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

Hi @MFelix,

 

I'm stumped.  I've matched the relationships as the two of you have described, yet the chart shows no data.  After creating a raw data table, I see that the Count measure for Closed Date isn't working because it's show a '1' even though no date exists for it.  I'm attaching my pbix in hopes you can help me figure this out.  

 

Many thanks.

 

 

 

 

Highlighted
Helper I
Helper I

Re: How to Use a Calendar Date Range to Filter Different Dates in a Table

I finally figured it out.  I had formatted my date fields from date/time to date in the table/data view, but not in the query. Once I transformed the date within the query the graphs worked. Lesson learned.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors