Forum Discussion
Ignore dates that provide no data in visuals
I have a dataset that records changes made in the company for some key parameters. We don't make changes everyday so the dataset will have entries like the following
| Date | Parameter A | Parameter B | Parameter C |
| 4/1/2020 | 40 | 24 | 150 |
| 4/15/2020 | 32 | 20 | 150 |
| 4/27/2020 | 45 | 22 | 120 |
| 5/1/2020 | 20 | 19 | 150 |
I was requested a visual like this, EXCEPT they don't want the space in between entries when we didn't make any changes.
Is that doable? Thank you!
Anonymous You could try changing the x-axis settings in the chart to "Categorical".
1 Reply
- DataZoe
Microsoft Employee
Anonymous You could try changing the x-axis settings in the chart to "Categorical".