Forum Discussion
Date
Yes, it's recommended to use a calendar table for that and you should start with a basic one and grow with the needs. Keeping the model cleaner is always important!
If you allow me i can also recommend to use the tool Bravo from SQLBI to create the date table. It's simple and it allows some customization to start.
If you want you can also use a calendar created in Power Query, there are some good example in the web.
Tell me if you need any more help!
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Yes, it's recommended to use a calendar table for that and you should start with a basic one and grow with the needs. Keeping the model cleaner is always important!
If you allow me i can also recommend to use the tool Bravo from SQLBI to create the date table. It's simple and it allows some customization to start.
If you want you can also use a calendar created in Power Query, there are some good example in the web.
Tell me if you need any more help!
Regards,
Sérgio Silva
SergioSilvaPT I ended up creating a date table. I am just not sure how to get it to interact with my other tables. I tried making a relationship with no luck. I'm really wanting any holes in my data to show. For example, if the plant is shut down for the day, I'd still like to see that date on my chart and right now it skips over those days.
villasenorbritt , you will have to connect the Calendar[Date] to the date on your Table[ShiftDate].
Something like this:
Here i connected Date with Sales Date.
Then, in the visuals you must use the columns on the Calendar to create date filters, you should even hide the shift date column on the table, as you can see on my sales table. At the end of each name it should appear an icon like an eye and if you click it it hides the column in report view.
Also you should create a measure for your Number of Samples like this:
Nº Samples = SUM(Table[Number of Samples])You should use this metric on the visuals.
If everything is correct it should only show days with data.
I hope it helps!
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.I am wanting to also show days with NO data as well. Sorry if I worded it weird.
No problem. That's easy, in the visual in the date value that you will use for example in the x-axis, you can see there is a down arrow. Click there and select an option that says something like Show items with no data.
Let me know if you need further help.