Skip to main content

Suporte do Power BI

Pesquisar

Re: PREVIOUSQUARTER returns nothing

Thanks, I suggest you open the PBIX file in the previous reply, as it will be faster for you and more informative that me trying to write a long post.   For time intelligence the date table is...

Re: PREVIOUSQUARTER returns nothing

I also downloaded the file, and to expand on the previous comment, PREVIOUSQUARTER finds the earliest single date visible in the current filter context, then returns the quarter previous to it. ...

Re: FILTERING using COLUMN HEADERS and VALUES

@paganomartin not sure for whom this message is for? You had two solutions one from @Ashish_Mathur and other from me. Which one you are referring to? Also when you said pie chart/card...

Re: Fill Map Visualization (Puerto Rico )

It's in the "State" field as 'PR', just like Texas is 'TX' and Massachusetss is 'MA'. There is no country code or data as it's all U.S. data/states. Example:   Address      &nbs...

Re: Power BI Report Server Embed for External Users

Hi there. have you tried this? https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-embed   Regards,

Re: can't sign up work email

My work email address contains an apostrophe.  It is an Outlook/Active Directory (I'm not sure where the system administrators actually created the address) created email address.  It is NO...

Problem comparing Budget and Actual tables

Hi guys!   I'm currently working on a report where we compare the budget vs reality of different accounts over a myriad of projects.      I only have 2 tables with all of...

Re: Case expressions may only be nested to level 10.

Hi there,   Same problem here. I downgraded to november's update, it worked just fine.   Probably something changed or is wrong in december version.     Waiting for solutio...

Re: TopN Customers Rolling 12 months

@mattbrice - I completely agree with you. I normally do NOT hard code items like. In this sample dataset I was working with - I needed to filter out some bad data associated with 2016 and force ...

Re: Power BI staff wins gold Stevie Award for Women in Business

Congratulations to Sandy and the whole team! 

US Department of Transportation - Traffic accident analysis 1990 - 2015

As part of the 2017 Gartner Data and Analytics Summit, @patbaum presented this impressive report to analyze Department of Transportation data for traffic accidents as part of the Modern BI Bake-...

Date hierarchy breaks DAX measure

I use the following measure to calculate a cumulative sum:  Cumul = CALCULATE ( SUM ('Query'[Indicator]), FILTER (ALL ('Query'[Date] ),'Query'[Date] <= MAX ( 'Query'[Date])) ) On t...

Help with temporal totals (TOTALYTD)

I've been having significant issues with getting TOTALYTD functions to work, having tried out a number of different permutations and combinations, all yielding the same result.   First and for...

Re: how to display in a Matrix measure name in Y axis and results on X asis

Generally, the solution to something like this is to use the disconnected table trick:   https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba...

Re: Get most recent values on new table column

@satlasg   Works like a Swiss Watch on my end. As you can see below both cacl column and measure work inside a visual too.   At this point, I would recommend you to try to implement the...

Re: Previous year DAX measure

 @smoupre thanks for your suggestion - unique patients is a measure so it won't let me put it in a SUM; would you be willing to share your email? I have the file in dropbox and could share ...

Dynamic calculate Measure value based on Slicer Selection

I have a table loaded in Power BI.  It has list of about 50 rows with two columns forming a category (7) and a sub-category (approx 7 per) hierarchy followed by 9 columns of characteristics...

Re: ESRI Symbol Colors STILL get stuck

I have the same problem but in desktop version - when i do not touche a model for some time - it changes suddenly colors to green! The same happens when i use some visuals changint the selection of ...

Power BI Rest Api Dataset in Power Bi Desktop?

Hi,   I effectively figured out how to associate a java application to Power BI REST API and figured out how to make a dataset and included a few information. I can see this information from ...

Re: datesadd(datesmtd) issue

Hi @Ashish_Mathur, I got the problem. It's because of the data. Sorry to bother you. Thanks anyway. I will keep in mind your suggestion next time.    

Re: Get most recent values on new table column

@nickchobotar There are no ID duplicates in Table B (Table 2), i double-checked through Count and Distinct Count, they have the same number as a result. So that is not the issue. Keep looking a...

Re: Bookmark property "Current Page"

Well, if you are on the correct page for the bookmark, then I believe the bookmark should still function. In my testing, it just doesn't save the page for the bookmark so that if you are on a differe...

Re: Utilization - Consolidated summary both horizontal and vertical

Hi,   That is just awesome!! Beautiful little code there!!     I got that to work.    Any suggestions on how to use the Conditional Formatting on the Row Subtotal?&nb...