Forum Discussion
Show x-axis values when no y-axis value is available
I have a data set similar to the one below. I would like to show date in the x-axis and event1 in the y-axis. As you see, there is not a event1 value for each date value, but I would like to see them all, event if no data is available. See screenshots below for clarification.
I need to do this when the variable in the x-axis is both categorical and continuous. Can you please provide solutions for both?
Thanks a lot
create a new measure and use an if statment to replace blanks with zeros
Event1Line = var ev1 = sum('Table'[Event1]) var ret = if(ev1 = BLANK(),0,ev1) return rettop line is using just to event1 colunm the second is a new line using the measure above
1 Reply
- AnthonyTilley
Solution Sage
create a new measure and use an if statment to replace blanks with zeros
Event1Line = var ev1 = sum('Table'[Event1]) var ret = if(ev1 = BLANK(),0,ev1) return rettop line is using just to event1 colunm the second is a new line using the measure above