Forum Discussion
Displaying a bar with zero values in a bar chart visual
- 2 years ago
Maybe try this?
-Make a copy of the "Date/Time" column in your fact table, then convert the data type of that column to Date, then create the relationship with that column. That will preserve the date/time column, untouched.
-Another option (I think I read somewhere that this enables your semantic model to be more optimized) is to split your date/Time column into two columns using Power Query: a Date column and a Time column. Then have the relationship be on the date column.
-You could also just convert your date/time column into a column with data type Date, but you'll lose the Time part. So it depends on your situation. If you don't use, and don't plan on using the Time part of your Date/Time column, you can do this with no problems.
A million thank you's for your help. You are a true expert.