Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |