Power BI-support

Sök

Re: Creating calculated columns for monthly totals

After my research,you can do these follow my steps like below: Step 1: Add two columns: Month = MONTH(Table4[Createdon ]) Year = YEAR(Table4[Createdon ]) Step 2: Add Total monthly sales   ...

Re: Discrete line chart

Hi @SebastianLM,   Maybe you can create two separate measures, one for  DROGUERIAS ATLANTICO and another for DROGUERIAS C/MARCA.   Regards, Yuliana Gu

Re: PowerBI

Hi @Parimal_Patil,   Could you please illustrate " but i want show the percentage region wise not against the entire user base. I have region and employee data. " with some examples? ...

Re: Second filter that would be between month beginning and ending

Hi @JMorningstar,   How does your data look like? It could be like below. SumAmtVar = SUMX ( FILTER ( _billings, _billings[_tsg_clientid_value] = accounts[accounti...

August 2018 release - Definitive links and blogs?

I have managed to download this and take a quick look. I am however having trouble tracking down the definitive list of links/changes. They are scattered through various forum posts here. I managed t...

Re: Displaying value on card monday, tuesday, wedesneday, thursday, and friday,saturday sunday toge

Hi @benjaminhoang, Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?   Regards, Daniel He

Create a MAX MEASURE which works in a timeline chart

I am sure there are tons of ways to do this, but since none of the ones I found here worked, I will share my findings.   Problem: I needed to show the MAX value as a separate line in a time-ba...

Re: Pie chart visuals filter the slicers

Hi @rdomingo16, Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?   Regards, Daniel He

Re: Calculate function with a filter based on another measures's value- fiscal month

Hi@ bayes You can try to use SAMEPERIODLASTYEAR function and DATESBETWEEN function like below: Measure 3 = CALCULATE(SUM(Table2[Qty]),DATESBETWEEN('Calendar'[Date],SAMEPERIODLASTYEAR(LASTDATE('Cale...

Re: mysql append query error

Hi @ccastelb - thanks a lot for posting the solution to this. Was going crazy trying to fix this - but your solution of just renaming a single column after doing the append made it work. &...

Re: 404 error when loading data to model

Thanks for your reply @v-shex-msft   I've traced the error to one of URL encoding. When loading the data to the model, Power BI is decoding a "%2f" in the URL to a "/", which must be enco...

Re: Previous month date

Hi @slyfox could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?   Regards, Daniel He

Copying reports from one workspace to another workspace using Power BI Rest APIs

Hello All,   I got requirement to copy reports from one workspace to another workspace using Power BI Rest APIs.   Several methods to get the response from Power BI api have been tested...

Number of Business Days

I have my source Days Out table as well as a Business Days table and a Holidays table...and they're alll working fine. The issue is when I filter the dashboard on the month, the number...

Re: Dynamic TopN made easy with What If Parameter

Hi GilbertQ, In addendum to the below query, my matrix doesn't filter to show only those cities (in my case clients). It does show the calculated top 10 amount in the grand total, but also shows oth...

Re: Issue with power bi report server august update.

Looks like the fwd link is not updated yet, we'll get it taken care of today. In the meantime you can use this link to download the updated August Edition of Desktop for PBIRS.   https://www.m...

Sync slicers and bookmark – How to leave out sync slicer from bookmark?

Hello Everbody,   I have a problem regarding the combination of sync slicers and bookmarking. I want to use bookmarking to reset slicers on page 2. However, by doing so also a sync slicer from...

Can't scroll to last tab in my report

I have a report with more then 40 tabs.  In the web interface as well as in the embedded web report I can't scroll right to the last tabs. This is a new issue that I discovered 2 weeks ago. ...

Re: Forecast Functionality in PowerBI

Hi Yuliana, I still could not have forecast function enabled even though my x-axis is date data type and it is a line chart. The x-axis is also continuous rather than categorial. Xiao

Re: Matrix total & subtotal row formatting

Any way to remove the default BOLD formatting from column and row totals of a matrix? The link earlier in this string isn't working.    Thanks, 

Re: Bullet chart visual from Microsoft showing nothing

@RMDNA   I'm not sure what your problem is and why you edited your answer 4 times. But I'm just stating facts and I have also linked to another thread where at least 5 other people have confir...

Re: Timeline Visual to Show Usage During the Day

Thanks for sharing about this great custom visual.  I have a similar problem to solve but I wasn't sure if this visual could achieve the following requirement -  I would like to show by "c...

Re: Finding first value with same ID in multiple rows based on date/time

@spocx try this   First assignment time = CALCULATE(MIN(Table1[Assign date/time]),ALLEXCEPT(Table1, Table1[Ticket ID])) assign team for first assignment= IF([First assignment time]=Table...

Issue / bug: Power Query M cross-database join fails - database connection info is switched

(Trying to post in "issues" forum, didn't see how to.)   My goal:   1) get data from server1/db1/table1 and from server2/db2/table2 2) union those 2 tables together 3) join the result...