Filter out text on column char X-Axis if the sum of its contents is < = 0

[JorgeMartinez92]

Hi all, 

I want to know if it's possible to filter out from my graph the months which do not have numerical values in the below table:

Employee Name	Recorded Hours	Target Hours	Missing Hours	Month
Jane Doe	0	1	1	AUG
Joe Doe	3	3	0	APR
Joe Doe	22	22	0	JUN
Joe Doe	0	1	1	MAY

This is what is currently being charted:

August has a total amount of 1 missing hours, so it is charted as well as May. I, however, don't want to see APR and JUN on the X-axis as there is no reason to display months without missing hours.

I was trying to calculate the sum of missing hours per month from my table and then create a measure which would filter said months if their missing hours amount is less or equal to 0, and then use said measure on the x-axis of my chart. But several attempts have not taken me any closer.

Can someone point me in the right direction?

 

[chonchar]

I got it to work

[chonchar]

Select View > Filters > Filters on this visual and then you can toggle on and off the months with no values. The problem with that is that it hard codes that into PBI, so if there were new data to populate in april or june, you'd have to toggle them back on to see the data. 

Hope this helps. 

[JorgeMartinez92]

Hi Chonchar, 

I have tried this one and does not work for me. Perchance you tried this option with the table I provided above?

[Anonymous · Accepted solution]

Hi @JorgeMartinez92 ,

I suggest you try to create a measure to calcualte sum of missing hours.

Sum of Missing Hours = CALCULATE(SUM('Table'[Missing Hours]))+0

Then set this measure to show items when value is not 0 in visual level filter. This will dynamiclly remove the month with 0 missing hours.