How to remove blank rows in stacked bar chart power bi,please help on this issue.

[Anonymous]

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

There is no direct option for us remove the blank rows in the stacked bar chart in power bi.

You may create the measure like below to get your desired output.

Measure = IF(MAX('Table1'[sal])=BLANK(),BLANK(),MAX('Table1'[sal]))
Measure 2 = IF(MAX('Table1'[sno])=BLANK(),BLANK(),MAX('Table1'[sno]))

Here is the output.

If you still need help, please share your data sample which could reproduce the scenario so that we could help further on it.

Best Regards,

Cherry