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.
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
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |