asking help
6 TopicsSince beginning of June 2025, Our report builder UI is tiny and the reports themselves appear broken
Hi, Since the beginning of June 2025, the UI on our report builder is absolutely tiny, and the design & interface on the reports are all over the place, but this hasn't affected the actual report. Below is an example of what report builder UI now looks like: As you can see, the 'Report Data' column, the folders are really small. Also, the graphs and tables of the report are all over the place:Solved5.3KViews0likes19CommentsConnecting to a SQL Server Problems
Hello, I have a Power BI Desktop downloaded on a remote desktop. I have on this Power BI Desktop a report that is connected to a SQL Server. When I publish the report to Power BI Service it fails to refresh. I downloaded the free Power BI Gateway on the remote desktop and connected it to the service, but it has failed to connect to the SQL Server. I need this data updated on the service daily from the SQL Server at 6am. I cannot seem to get it working. Please advise. Thank you, Fools_GoldSolved701Views0likes1CommentDax formula for matching string values between different columns for conditional formatting purposes
Hello Community, I am trying to dax the following logic to be able to use it as a conditional format on a matrix table " Project Column" under the below logic. So the logic says if the project mentioned is tagged to any of the projects subtypes give me a 0 and if not than 1. Here we have 3 projects with their assigned subtypes and no subtype of another project should be tagged to any to other project. WhenI created the below dax, it looks correct but it is not working and giving me an error when I try to set it to the field "projects" as conditional format so not sure if it is working or even daxed right. Any help and guidance would be Super! Improper Program Tagging - CF= MAXX('Table1', IF('Table1' [Project]= "Creativity" && 'Table1' [Project Subtype] IN {"ABCD","Crafts","CDO", "PR", "MF 6"}, 0,1) || IF('Table1' [Project]= Toys" && 'Table1' [Project Subtype] = “Lego",0,1) || IF('Table1' [Project]="Online Gaming" && 'Table1' [Project Subtype]= "Avengers",0,1))Solved1.8KViews0likes6CommentsMatrix Table with multiple layers breakdown
Hello guys, I have a question that is challenging me and I am struggling to find the write way to visualize it in a matrix table. I have a table as below and I want to create a matrix table where It will show me the headers as the first row and then the breakdown will be Project name, WBSE code, contract number however The key question is how would I make the project name row shows the key numbers and then the wbse row shows only the values set to it without repeating the values above and similarily the contract number values while wbse and contract values will sum to the initial project name row values. Is that possible? Project Name XYZ Location ERP Number Money Allocated Money Spent Money Saved Actuals Total Budget New Total New Budget Department 2 Contract price Project 1 Calgary ZH-000123 $ 50,000 $ 750,000 $ 25,000 $ 5,000 $ 830,000 $ 792,500 $ 150,000 $ 280,000 $ 10,000 Pro - 1 - WBSE $ 25,000 $ - $ 25,000 $ 5,000 $ 55,000 $ 42,500 $ 25,000 $ 30,000 $ 10,000 Contract 1 $ - Contract 2 $ 10,000 Pro 2 - WBSE 2 $ 25,000 $ 750,000 $ - $ - $ 775,000 $ 750,000 $ 125,000 $ 250,000 $ - Contract 3 $ -Creating custom column with Multiple condition on Column
Hi All, I have a table containing the list of multiple items and values like below Item Name Value Kp123_K1 29.35 FK569_K1 11.5 Kp123_K2 30.25 FK569_K2 13.11 Kp123_K3 26.56 FK569_K3 12.00 In the new column, I should get if (item name(FK569_K1)<11.9) then item name(Kp123_K1 )* 24 if the condition is satisfied value will return( Ex. 29.35* 24) else false should be return. Can any one help me the dax formula for this to get new custom column Thank you for the helpSolved783Views0likes3Comments