Card pulling wrong data
Good Day, I have multiple excel documents in SharePoint and each excel workbook has a tab called Availability. I pulled each availability sheet into powerbi and i want to display the balance leave for vacation, sick and business. When i created a card to represent the balance leave, say the balance leave for vacation is 40..it is say 534K ...i tried to change the sum to count or dont summarize and it still is displaying the high number. Any feedback would be appreciated.
Mekko Chart sorting- How to sort y axis cost per unit in ascending order in a Power BI Mekko Chart?
MEKKO CHART SORTING This is a Mekko Chart. I have to sort it either by ‘index’ ascending order or ‘cost per unit’ ascending order. Both will do. Right now without sorting, I'm getting chart A but the aim is to get chart B. I am using the Power BI tool. Any help on how to make this chart or how to do sorting is highly appreciated. Thanks in advance.CASE STATEMENT TO DAX?
Hi Community, I want to convert this CASE STATEMENT SQL Query to DAX? SQL Query: 1. DayDiff(AddMonths(min(month),3),min(month)) AS tot_days, (Measure 1) 2. CASE WHEN daydiff(Now(),min(month)) > DayDiff(AddMonths(min(month),3),min(month)) THEN DayDiff(AddMonths(min(month),3),min(month)) ELSE daydiff(Now(),min(month)) end AS days_completed (Measure 2) Is it possible? Reg, DhanaPower BI Report Server and SSAS Connection- Login Failed error
My SSAS is on remote server different domain. I have used runas net only command to connect to SSAS from my Power BI desktop and developed the report. I have published the report to Power BI report server. In web Portal under 'manage-> datasources' I have used 'Using Following credentials' option and edited the credentials. Despite providing the right credentials it throws the below error 'Log on failed. Ensure the user name and password are correct.' Thanks in advance. Can we export Power BI Report using URL access?
There is a feasibility in SSRS(using rs:Format) to do the same. Here is the link https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-2017 Can we do something similar for reports published onto Power BI report server? Is there any option other than 'File->save as pdf' in webportal to export the reports/graphs into pdf.
