How to hide target bar when no sales amount ?

[admin11]

Hi All

I have sales vs target chart.

Since now April , it have sales and target , it is good to show . 

Since May only have target but no sales , may i know how to hide these bar ?

My PBI file :-

https://www.dropbox.com/s/edkfksg0pcf1me6/PBT_V2021_400%20TA_SI.pbix?dl=0

Paul

[HarishKM]

@admin11 Hey . Use this 

test = if(sales[sales]<> blank(),target[target], Blank() )

Try this it will fulfil your requirement 

[v-yetao1-msft · Accepted solution]

Hi @admin11 ，

A simpler way is to filter the data you want can through visual filter. You said you want to hide the bar that only have target but no sales .That means if the sales is equal 0,the targets will not display also .

So set SALES_  is not 0 in visual filter , you will get the result you want .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-yetao1-msft 

Thank you for your help.  Your approach using sales is not 0 , does it mean that if I change the setting to sales > 0 , it will also work in theory right ? Then why PBI need to provide sales is not zero ?

[v-yetao1-msft]

@admin11 

If you change the setting to sales > 0 , it will also work . As long as your setting is opposite to 0, it can meet your needs . You can try to set .

[admin11]

@v-yetao1-msft  your approach work fine , many thank.

[amitchandak]

@admin11 ,

if( isblank([sales]), blank(),[target chart])

[admin11]

@amitchandak 

Thank you for sharing.

I am not able to get the field name for TARGET CHART. I get error.