cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shilpi1012 Frequent Visitor
Frequent Visitor

How to relate date table with detail data table

Hi

 

I have a scenraio where i have created a date table from 2015 to 2020. I have detail data table where i have data just till 2018. Now I have a bar chart where i am showing data for every year where in i am taking year columnfrom date table.

 

Now the problem is that bar graph only shows data for years till 2018.

I want that those two years also come in the bargraph and replaced with 0 if theer is no data.

 

How can we achiee this.

 

Regards

Shilpi

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to relate date table with detail data table

Hey,

 

from the context menu of the column used as x-axis, your year column from the date table, just select "Show items with no data":

image.png

 

Hopefully this alreay will provide what you are looking for.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Super User
Super User

Re: How to relate date table with detail data table

Hey,

 

from the context menu of the column used as x-axis, your year column from the date table, just select "Show items with no data":

image.png

 

Hopefully this alreay will provide what you are looking for.

 

Regards,

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,416)