Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 Hey . Use this
test = if(sales[sales]<> blank(),target[target], Blank() )
Try this it will fulfil your requirement
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.
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 ?
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 ,
if( isblank([sales]), blank(),[target chart])
Thank you for sharing.
I am not able to get the field name for TARGET CHART. I get error.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |