Blank Values
How to handle blank values?
When you have blank values in your data like this:
| Process Id | Event Id | Next Event Id | Event Label |
|---|---|---|---|
| Process With Blank Values | 10 | 20 | A |
| Process With Blank Values | 20 | 30 | B |
| Process With Blank Values | 30 | 40 | |
| Process With Blank Values | 40 | 50 | D |
| Process With Blank Values | 50 | E |
Your process is broken due Power BI ignores blank values as default.
You need to set "Show items with no data" checked to Event Id and Next Event Id
After this, process can be seen normal.
TIP
You can set value to be show in blanks from settings (Dev Tools -> Blank Values).
See sample report for example (can be downloaded from AppSource).