Chart Filtered

[Anonymous]

Hi Gurus, 

I have a pretty hard requirement (to me).

I need to filter only the Planned hours bar that are 'Closed'. this value comes from a column, when I filter the chart it apples to whole visual ( Including COV-CANC,COV-CONT, COV-HLD2 etc..) I only need to filter PLANNED bar. is there anyway to acheive this impossible. 

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak , only few rows, what I want is to exclued PM_ORDER_SYSTEM_TYPE that include CLSD from only PLANNED Rev_Group.

PM_ORDER_SYSTEM_STATUS	PM_ORDER_USER_STATUS	Total_Hours	Status	Displayed	Rev_Group
CNF,NMAT,PRC,PRT,SETC	E1	15	CLSD	False	PLANNED
TECO,PCNF,DLFL,NMAT,PPRT,PRC,SETC	E1	90	CLSD	False	COV-HLD2
CLSD,NMAT,PRC,SETC	CANC	1	CANC	False	PLANNED
CLSD,CNF,CSER,GMPS,MACM,PRC,PRT,SETC	E1	86	CLSD	False	COV-CAN

[Anonymous]

Hi @Anonymous ,

Is below column what you need?

Here is the dax expression:

Column = 
var _check=SEARCH("CLSD",'Table'[PM_ORDER_SYSTEM_STATUS],1,0)
Return
IF('Table'[Rev_Group]="PLANNED"&&_check=1,BLANK(),'Table'[Rev_Group])

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!