Forum Discussion
How to remove Blank Bars from Clustered Column Chart.
Hi All,
I want to remove Blank bars from chart or i want to show Blank at end of chart.
Could someone please help me on this.
Regards,
Mahesh
8 Replies
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).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.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.
