Forum Discussion
exclude blank X-axis
Hi,
I would like to create a column chart that shows my actuals based on the current YTD period (in this case it goes till month 10).
I have added in my X-axis the current YTD period and in Y-axis Actuals. Somehow in the visual it shows me a blank month (I guess for month 11 that is not in current YTD period). How to exclude this blank month?e
| month | actuals |
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
| 4 | 400 |
| 5 | 800 |
| 6 | 100 |
| 7 | 200 |
| 8 | 300 |
| 9 | 400 |
| 10 | 600 |
| 11 | -500 |
| current ytd period |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
Thanks
Regards
2 Replies
Hi Anonymous,
Just go to the Filters pane and unselect (Blank).
Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
