Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Caiz
Frequent Visitor

Hide values in bar chart where value is 0

I am using a clustered bar chart to display the Sick Days taken by different teams.

 

Here is a sample of my table:

 Sales TeamDevelopment TeamOperations TeamProduct Dev Team
Sick days taken0320

 

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.

4 REPLIES 4
amitchandak
Super User
Super User

@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:

Australia Sales Team SL = var _1 = calculate(sum('Sick Days'[Australia Sales Team]))if(_1 =0, blank(),0)))
 
Error: The syntax for 'if' is incorrect. (DAX(var _1 = calculate(sum('Sick Days'[Australia Sales Team]))if(_1 =0, blank(),0))))).
 

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors