How to remove the blank values from a clustered column chart?
I have a clustered column chart with values displaying per quarter. There are few blank values and the bars are shown up even for the blank values like empty spaces. I tried all the ways to get rid of the blank values like setting the visual level filters set not to be blank, through DAX ( if(value=blank(),0,value). But none of the ways are working. Still I am not able to get rid of blank spaces.
Is there anyone who has seen such issue and able to remove the blank spaces between the bars? If so, please help me with the solution>
So based on your approach, I made sure that the "Show items with no data" is unchecked, x-axis is categorial and changed my measure to be blank() and then applied a visual level filter for my values as "Is not blank". Still I could see the blank spaces for the bar with no data. I could not identify for what reason blank() condition is not getting applied to the measure values and why I am not able to filter out those values in the graph. A ref pic is below:
@Lakshmi_Koduri Thanks for the picture - it helps a lot to see the problem.
Because you have put Year in the Legend field, it will keep the blank spaces for consistency.
Do you like any of the alternative options below?
Top left is using custom marketplace visual by Akvelon with "Column by" Quarter and under Format: "X-Axis > Axis Range Type" set to "Separate". Bottom left changes chart type to stacked column. Bottom right puts both quarter and year in Axis, expands down a level and under Format > Data Colors > Show All > On and customize the colors as you want.
None of them are exactly what you're looking for, but hopefully helps a bit?
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.