Supporto di Power BI

Re: Calculate date specific measure with another table's dates.

Hi,   Share some data and show the expected result.

Re: Count grouped by column A for each value of column B

Hi,   Create a matrix visual.  Drag Email to the row labels, Boune_type to the column labels and write this measure   =COUNTROWS(Data)   Hope this helps.

Re: Error with the mail subscription (mail is blank)

Any update on this?   Couldn't find anything under Awareness. I have been facing the same issue since 10th June 2018.   Have this issue been rectified? Kindly let me know if there are a...

Re: slicer numéric input

Hello everyone, I find myself reading again, that my question is not accurate enough. I have a list of about 30000 file number, and I wish I could filter only one by writing its number, no graphic ...

Re: DAX Expression help needed

Hi Ashish,   all are caculated columns.

Filter by date column

Hello, community! I'm new in power bi and I need your help I have a table "Cash_flow", there are the columns with: flat ID, contract ID, date contract value. One flat can have several&nbs...

Re: slicer numéric input

thanks, it's perfect .Nico

Re: Count grouped by column A for each value of column B

I ended up doing this:   Let's say you have a table like this: Site Type Đặt hẹn với phiên dịch viên trực tuyến hard オンラインで通訳を予約する  hard オンラインで通訳を予約する soft 통역사 온라인 예약&nbs...

Re: Total of measure

Hi @veron1990   This calculated measure gets pretty close.  I have attached my copy of the PBIX File.   Measure6 = IF( ISFILTERED('Sheet1'[kraj]), --If no...

Many to mAny relationship

Hi All,   Why doesn't power BI allow Many to Many relationships?   What happens in the background. Why cant we do it here when we can do the SAME thing in SQL SERVER. (As I am...

Re: Subscription to emails result in grey image in the body of the email

@nhol, You get blank dashboard in subscription email, right? if so, t his is a known issue. Please provide me your email address, tenant id, dashboard URL and tenant location via private messa...

Re: Display top 3 filter - seeking advice.

Hi @steambucky, Based on the example that you have given I have derived my below suggestion. Hope this suits your need!!   As you need to display only the TOP 3 Animals, there is no doub...

Re: Gantt - Sub Tasks & Parent

Hi @Aash_   Apologies, I haven't worked out yet how @doubleJSA's screenshot came about.    It may be to do with versions (a prior version had functionality and it's now n...

Re: Sum of Max's...

Hi @Frunkis   I downloaded your sample data and loaded it into Power BI, but just struggling to get something that looks like your screenshot so I can help with the SUM calc.   I'v...

Re: Power BI Access Token and Dashboard ID

Hi  @Thimma,   For your requirement, you may get an access token from Azure AD. T hen, you load the dashboard using the same access token. for more details, this article will help...

Re: Parameters from power BI desktop to services.

@zlokeshI am positive, that parameters work in Power BI service. The thread you posted is one year old and this feature is very recent.   Would it be possible, if you posted Power Query code? ...

Re: find sum of total from calculated column

Hi Cherry,   thanks to reply,   may i know query "format" is which data type?   because when i executed the query and measure is working fine, and once i drag it in to any widget...

Re: Report Format

@Dailey, It is not possible to drag the plot outside of a report page. If you concern about the page size, please check if the page view option meets your requirement. Regards, Lydia

Re: QPage tagging in q&a for Power BI Embedded is giving 401 error

thanks for your suggestion. I have embedded the app successfully but unable to call the report page by using qna query. I don't know how to trace that request.

Re: Taking Data from another table (Without relathions)

Oh!! It's Works.   I've to change the field because it's not the table where i've to do the calculations. Thanks to your comment i noticed that (Thank!!)   The last thing I don't solve ...

Re: Line Chart online bug, desktop is ok

Hello,   I found same weird effect a couple weeks ago. My company users are going crazy because the line chart doesn't show data correctly when they use some filters combination.   Plea...

Re: On Premises Gateway: "The Operation is Timed Out" - Status changed to: Needs Info

Re: On Premises Gateway: "The Operation is Timed Out"

Hi @kehamilton92,   When you launch the on-premise data gateway application, is the gateway online like below(You might need to click on Sign In to enter your email addre...

Re: Averaging Rolling Quarters without Filter

Hi Rose,   I can't access the file. It asked me to log in.   Best Regards, Dale

Re: Add Quarter in Calender

"Quarter" , "Q" & INT((MONTH( currentDay )/4)) + 1)