filter working completely fine in Desktop, not working in service

[007Raj]

Hello everyone

I am facing an issue, filter working completely fine in Desktop, not working in service

There is an error "cant display the visual." and following is the error description.  Kindly let me know if you need any further info in order to resolve the issue.

Activity ID: af886b97-86fc-40bf-83fe-4d757698ac47
Request ID: bcf0b6a5-d285-4e46-bf37-2f229dbca864
Correlation ID: e413f8ee-2af8-3b0f-9659-3b3b7bdceb83
Time: Tue Sep 20 2022 10:57:28 GMT+0300 (Arabian Standard Time)
Service version: 13.0.19087.45
Client version: 2209.2.13242-train
Cluster URI: https://wabi-west-europe-redirect.analysis.windows.net/

@amitchandak 

[Anonymous]

Hi @007Raj 

What filter criteria did you set ? Can you reproduce your filter with screenshot or video ?

Best Regards,
Community Support Team _ Ailsa Tao

[007Raj]

Following is the dax:

P&L By Brand =

VAR _SalesCY = ROUND([Sales], 0)

VAR _GrossProfit = ROUND([Gross profit], 0)

VAR _NetProfit = ROUND([OprNetProfit], 0)

VAR _OperatingProfit = ROUND([Operating profit], 0)

VAR _StoreNetProfit = ROUND([Store net profit], 0)

VAR _SalesBud = round([Bud_Sales], 0)

VAR _GrossProfitBud = round([Bud_Gross Profit], 0)

VAR _NetProfitBud = ROUND([Bud_OprNetProfit], 0)

VAR _OperatingProfitBud = ROUND([Bud_Operating Profit], 0)

VAR _StoreNetProfitBud = ROUND([Bud_Store Net profit], 0)

VAR _SalesLY = ROUND([Sales LY],0)

VAR _GrossProfitLY = ROUND(CALCULATE([Gross profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _NetProfitLY = ROUND(CALCULATE([OprNetProfit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _OperatingProfitLY = ROUND(CALCULATE([Operating profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _StoreNetProfitLY = ROUND(CALCULATE([Store net profit],SAMEPERIODLASTYEAR ( DATESYTD ( dimDate[Date]))),0)

VAR _Result =

SWITCH (TRUE(),

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesCY, _SalesCY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfit,_GrossProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfit,_NetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfit,_OperatingProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfit,_StoreNetProfit,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "CY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfit, _SalesCY, BLANK()),"0.00%"),BLANK()),

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesBud, _SalesBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitBud, _GrossProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitBud, _NetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitBud, _OperatingProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitBud, _StoreNetProfitBud,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_GrossProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_NetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_OperatingProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "Budget" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesCY, FORMAT(DIVIDE(_StoreNetProfitBud, _SalesBud, BLANK()),"0.00%"),BLANK()),

SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Sales", IF(_SalesLY, _SalesLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Gross Profit", IF(_GrossProfitLY, _GrossProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Net profit", IF(_NetProfitLY,_NetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Operating Profit", IF(_OperatingProfitLY,_OperatingProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "Store Net Profit", IF(_StoreNetProfitLY,_StoreNetProfitLY,BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Gross Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_GrossProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type])
= "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_NetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Operating Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_OperatingProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK()),
SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Index]) = "Store Net Profit" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Period Type]) = "PY" && SELECTEDVALUE('dimPeriodsP&LBrand&Loc'[Description]) = "% to sales", if(_SalesLY, FORMAT(DIVIDE(_StoreNetProfitLY, _SalesLY, BLANK()),"0.00%"),BLANK())
)

Return

_Result

following is the desktop setup

following is the power bi service error:

[007Raj]

Hi everyone
thank you for your support.
The issue resolved on its own after 3 days (expected it to be much earlier)

I want to apprise to other developers that there is sometimes glitch from the backend (Microsoft's end) that some slicers does not work in power bi service but works fine in desktop and it was working fine earlier in service as well as desktop during testing and such glitches which does not require any intervention from developers but wastes a lot of time so be mindful of it.

Thank you

[Anonymous]

Hi @007Raj 

I am so glad to hear that your issue has been fixed . Thanks for your reminder. I will change the status to "Delivered" .

Best Regards,
Community Support Team _ Ailsa Tao