Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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 ret
top line is using just to event1 colunm the second is a new line using the measure above
Proud to be a Super User!
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 ret
top line is using just to event1 colunm the second is a new line using the measure above
Proud to be a Super User!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |