Forum Discussion
How to remove Blank Bars from Clustered Column Chart.
Have a look at this, although it's quite straightforward. I'm not certain if it aligns perfectly with your requirements.
You should inspect the Filters pane and identify the field leading to the appearance of empty bars in your graph. This is usually the field you've assigned to your chart's Axis. You'll want to adjust this filter to exclude blank entries.
OR
Alternatively, as a hypothetical scenario, consider that I've composed a DAX measure which tallies the sum of 'ProductSales' only when 'Region' isn't empty. Consequently, it prevents the blank 'Region' entries from being displayed on the chart.
Product Sales (No Blanks) =
CALCULATE(
SUM('Sales'[ProductSales]),
'Sales'[Region] <> BLANK()
)
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Hi Manoj_Nair Thank you for your response. I tried both the ways but still issue was not resolved. Can you please suggest me any other approach.
Maheshgm- Can you pls, send me a sample dataset or PBIX file, remove all confidential info.
Hi Manoj_Nair I try to send file but I'm unable to attach it. How can I attached PBIX file to chat ?
