Skip to main content

Power BI

Needs Votes

options for visualualizations to include empty columns or rows

Vote (5) Share
Leigh's profile image

Leigh on 12 Jul 2018 05:19:43

Currently, in charts, tables, and matrices, empty rows and empty columns are skipped. If one is trying to get an idea of sales over time, it might be nice sometimes to include the columns that would otherwise be skipped.
This would be especially helpful in a chart or graph where one wants the trend to be immediately evident. Skipping columns as is done now gives an unrealistic view of the trend.
It is currently possible to get rows to all appear using a custom measure for the matrix or table, but there isn't a way to get an empty column to appear.
I'd like to see two options:
o Include empty rows
o include empty columns

This would get rid fo the need to create the measure to get rows to appear, and also prevent the problem of empty columns.