Cannot connect Power BI with SQL server
Hi, I found issues with connecting Micsrosft SQL Server with Power BI. I do not have any experience in such connections, so I am blindly doing different steps but I simply don't uderstand what I am doing, hence I am not able to know what's going wrong. So, I read I need gateway installed, and I did. Install an on-premises data gateway | Microsoft Learn Then I set up gateway name and key based on another article. And then, what's next? I found this article Add or remove a gateway data source - Power BI | Microsoft Learn but I am unable to folllow steps, I can't find setting button. Do I need any additional version or access to be able to complete this? I tried to put in Power Bi credintials that theye were given to me around the server, but no luck with any connections. Instead of Server name, I have Port number, but I reckon this is the same. I put passowrd and user's name into Power BI server query, but I encounter error message, hence I think this gateway needs some further steps I haven't completed yet? Thanks!
custom table visual
Hello, I am creating a custom visual as below, In the input column i give some numbers and it calculates the percantage as Totalsalescost/Input But in percentage column the result gets reflected only when i increase or decrease the size of table created.How can i solve this so that percentage column gets reflected as soon as i enter input value This is the snippet I used Please help me with this
Date Table 12 week period
I have a Date Table which in the 12 Week Period Column creates a new period for every 12 weeks as per the column highlighted. What the 12 Weeks Period is doing through is going back to 1 at the beginning of the new year so for Date 01 January 2024 the 12 Weeks Period has gone back to 1 but there are not 12 weeks in Period 5. How do I get the column so it just rolls on without returning back to 1 for a new year? danextian Anonymous Anonymous tamerj1Measure for colouring columns on a higher aggregation level than detailed data
Hi there I kindly request your help/hints on the follwing, because I am stuck somwhere in between... I need to color a column chart based on the average out of X Months, whereas No of months is from a relative date slicer The data are weekly based (Date of Sunday) and is counting number of contracts: MyMeasure = Sum( MyTable[NoOfContracts] ) Using my datetable I am visualising MyMeasure in a columnchart I wrote a measure to get the average per No of selected Months: MyMonthlyAverage = AVERAGEX ( VALUES( calendar[MonthYear]), MyMeasure ) Based on the relation between MyMeasure and MyMonthlyAverage I want to decide the color of the column, "Geen" for above, "Red" for below MyMonthlyAverage. Unfortunateley it seems that the number per Month (MyMeasure) is not divided by no of months but by the number of Sunday-dates in the selected period (e.g. MyMonthlyNoOfContracts / No of Sunday-Dates (52) and not MyMonthlyNoOfContracts / No of Months selected (12)) MyColumnColor = var check = [MyMeasure] var limit = [MyMonthlyAverage] return SWITCH( TRUE(), check < limit, "Red", "Green") Aways "Green" gets returned and so are the columns Question: What is the Syntax to write a correct and proper MyMonthlyNumberOfContracts? Appreciating your Input thx in advance Thomas
Issue with SELECTEDVALUE function when used with CALCULATETABLE in DAX
Hello, I am currently working on a report where I've dedicated a page to individual companies. Users navigate to this page via "drill through" from another page. On this particular page, I would like to see other companies that are within the same industry as the company in question. With that aim, I have constructed the following DAX formula: SummarizeTable = VAR CurrentIndustry = SELECTEDVALUE('Account Meta Data'[Industry]) VAR CompanyList = CALCULATETABLE( VALUES('Account Meta Data'[DatabaseName]), 'Account Meta Data'[Industry] = CurrentIndustry ) Return CompanyList However, the CompanyList produced doesn't align with my expectation. It seems to comprise of companies which lack industry definitions in my Company Meta Table. Although I have tested the CurrentIndustry = SELECTEDVALUE('Account Meta Data'[Industry]) measure separately and confirmed it produces the correct value, it doesn't seem to function as intended within the CALCULATETABLE function. When I replace CurrentIndustry with a specific industry value (for example, "Agriculture"), the list is generated correctly. Could someone kindly help me understand what might be wrong? Any assistance would be greatly appreciated! Best regards, Brenda
