Forum Discussion
Post PatronDate Table won't appear in visual
I have a table that has a column with dates on it. Some dates don't appear as there simply isn't any data for those specific days. I created a simple date table that shows today through two weeks with the hope that using it will allow my visual to show the empty days as empty. I have a 1:M relationship between my date table and the column with dates in it for my data. When I
Date Table:
Your Model should look roughly like this:
And your visual should look roughly like this with these fields from the specific tables I am pointing to:
And the Row Count measure is this:
Row Count = VAR RowCount = COUNTROWS(Sales) RETURN IF(RowCount = BLANK(), 0, RowCount)If that isn't working, please at a minimum show us the fields you are using in your visual, as well as the model view, or better yet, just put a PBIX file with no confidential info in OneDrive and share it here.
Is this what you are looking for? You said page 4, but this is on page 5, and I saw the bar chart. I didn't fully understand what you meant when the top chart should look like the bottom chart when one is a line chart and the other is a bar chart. But I do see where the line chart is missing data.
I made a new measure called "Reconnect Residential" that is next to your "Reconnects Residential" (mine is singular, yours plural) and I get a purple line all the way across, with most being zero as that table only has days, but my line shows the zeros whereas yours stops.
So it is the measure I posted above, but specifically:
Reconnect Residential = VAR RowCount = COUNTROWS('INSTALL 2 WEEKS RECONNECTS RESIDENTIAL') RETURN IF(RowCount = BLANK(),0,RowCount)Is that what you were looking for?
As an aside, I made your date table a true date table. You have to click on it in the Report tab, select "Mark as Date Table" and then point out the date field. Not terribly relevant in this example, but it isn't a date table until you tell Power BI it is.
The updated PBIX is here. If that isn't right, can you be more specific about what you want telling me the exact name of the tab that may have two visuals that are the same, where one is right and the other is wrong?
11 Replies
- amitchandak
Super User
If you can try. Put the count of date from date table into tooltip and check
- edhans
Community Champion
- Make sure the date you are putting in your visual is from your Date table, not your data table.
- You can click on the dropdown next to the Date field in the visual and tell it to "Show items with no data"
Often visuals won't show blanks. Another approach is to use a measure.
Total Sales = VAR TotalSales = SUM(Sales[Sales]) RETURN IF(TotalSales = BLANK(), 0, TotalSales)That will return 0, not blank.
GunnerJAfter I checked "Show blanks" I see the dates but my data simply isn't filling in as a would expect. It doesn't recognize the dates it would seem.
I double checked and the date field in my data table is a date type. I don't understand why it won't populate correctly. All I want is a count of the rows by the displayed dates.
- edhans
Your Model should look roughly like this:
And your visual should look roughly like this with these fields from the specific tables I am pointing to:
And the Row Count measure is this:
Row Count = VAR RowCount = COUNTROWS(Sales) RETURN IF(RowCount = BLANK(), 0, RowCount)If that isn't working, please at a minimum show us the fields you are using in your visual, as well as the model view, or better yet, just put a PBIX file with no confidential info in OneDrive and share it here.
- kentyler
Solution Sage
Power BI has a setting to show items with no data https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data
