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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Partisan
Post Partisan

Slicer selected value bars shouldn’t appear in chart

 i have data based on week wise  here my   i want hide slicer  selected values 


DatePA = DISTINCT((VALUES('Append1'[Week Date])))
month no 2 = FORMAT(DatePA[Week Date],"yymm")
monthno = FORMAT(DatePA[Week Date],"yymm")
final column for slicer 

WEEK = var a = DATE(2020,08,03)
var b = IF(DatePA[Week Date] = a,"Outbound GLOBAL",IF(DatePA[Week Date]<>BLANK(),"Outbound" & DatePA[Week Date]))
return b
 if i select july month july bar houldn’t appear 
i am using three values for column chart 
Uptime : 
Up time = CALCULATE(
DIVIDE([calc op per day],[calc op per day manne]),
FILTER('PA - E2PR',AND('PA - E2PR'[Year] = MAX(calender[Year]),'PA - E2PR'[Week Date]=MAX(DatePA[Week Date]))))
Uptime MINT Average =
var a = SELECTEDVALUE(DatePA[monthno])
var yearend = ENDOFYEAR(calender[Date])
var result = IF(MAX('combine effective date'[month no])>=a && MAX('combine effective date'[Effective Date])<=yearend,[Increase in Average],BLANK())
return result
Weight MINT = var a = DATE(YEAR(MAX(DatePA[Week Date])),MONTH(MAX(DatePA[Week Date])),DAY(2))
var b = DATE(YEAR(a),MONTH(a)-1,DAY(a))
var c = DATE(YEAR(a),MONTH(a)-2,DAY(a))
var d = DATE(YEAR(a),MONTH(a)-3,DAY(a))
return IF(MONTH(MAX('Append1'[Effective Date]))&YEAR(MAX('Append1'[Effective Date])) = MONTH(b)&YEAR(b),0.5,IF(MONTH(MAX('Append1'[Effective Date]))&YEAR(MAX('Append1'[Effective Date])) = MONTH(c)&YEAR(c),0.3,IF(MONTH(MAX('Append1'[Effective Date]))&YEAR(MAX('Append1'[Effective Date])) = MONTH(d)&YEAR(d),0.2,BLANK())))


also if i select july month  previous thre month only apperar  April,May.June . 


any idea thanks in advance 


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.