Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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/
Solved! Go to Solution.
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
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
Hi @007Raj ,
I suggest that you can try the followings:
1, Check if the connection of dataset is correct. Because if it relates to Direct Query Mode, it will need an on-premises gateway connected correctly to show the visual.
2, Check the measure you created.
3, Try checking the memory, as not having enough memory will cause the visuals in the report to not display properly.
4, Try to swap for another visual to see whether it can be shown up.
Please refer to the following document:
Tips and tricks for creating reports in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @Greg_Deckler
I had already raised issue 4 hours ago, did not receive any response from anyone, hence posted here
@007Raj So when you say the "filter is working/not working" are you referring to when you select something in a slicer, in the Filters pane or ? Also, what visual are you using? How is the visual configured?
its a matrix visual which is giving error when sliced via a slicer
The visual is configured using disconnected table. Column headings are fetched from disconnected table, rows are from another table, and switch statement is used to display values in the matrix.
@007Raj Sounds fairly innocuous. Mind sharing the measure formula? Maybe there is something there that is causing an issue.
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:
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 desktop setup
following is the power bi service error
@007Raj Only Microsoft speaks correlation IDs. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".