Forum Discussion

PaulF0901's avatar
PaulF0901
Regular Visitor
2 years ago
Solved

Displaying a bar with zero values in a bar chart visual

Hi,   I have a challenge when it comes to displaying a bar on a bar chart for a value that doesn't exist. Let me explain.    I have a table of logged user activities similar to the following:   ...
  • kpost's avatar
    kpost
    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.