Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using a clustered bar chart to display the Sick Days taken by different teams.
Here is a sample of my table:
Sales Team | Development Team | Operations Team | Product Dev Team | |
Sick days taken | 0 | 3 | 2 | 0 |
My chart is currently showing all 4 teams, even those with the value of 0. How do I get it to only showing teams with more than 1, and not show the Sales & Product Dev Team on the chart?
I've tried look through a few forums and can't find a solution, I also can't do an advanced filter for some reason on e.g. "Sales Team" to only show values more than 0.
Thanks for your help.
@Caiz , If they column the only thing you can do is
Sales Team leaves = var _1 = calculate(sum(Table[Sales Team]))
if(_1 =0 , blank(),0) //You need to create for other three
If the team is column value then
Team leaves = var _1 = calculate(sum(Table[Team]))
if(_1 =0 , blank(),0)
Hi @amitchandak , I am getting an error for the following query:
@Caiz , Try like
Australia Sales Team SL =
var _1 = calculate(sum('Sick Days'[Australia Sales Team]))
return
if(_1 =0, blank(),0)
@amitchandak Unfortunately it's still showing this new measure in the chart even though the value is 0
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |