Soporte técnico de Power BI

Buscar

Microsoft Office Uses Power BI to Showcase Survey Findings on the Future of Teamwork

Microsoft Office recently used Power BI to create an infographic about a survey they conducted on the topic of the future of teamwork. The result provided an interesting and engaging way to share fin...

Re: On Premise Data Gateway is not available when merging Odata feeds with (Excel) files on a folder

Hi, we have the exact same problem. Any fix on this? Is really important! Nor a workaround? Thnaks!

Re: grouping question

where is the "Total" that I need to turn off? I did not get that part.   Also, I already tried doing count on Health Plan the way you showed me. That would not work I think because I am gettin...

Zambia Southern Province Confirmed Malaria Cases

#MakeoverMonday W16 challenge      The data is a simulated data set based on actual malaria case counts detected by Zambian Ministry of Health staff who are part of the Visuali...

Unable to get LYTD info

Hello,   One of the Projects I am working on, I have to show YTD vs LYTD comparison on a bar chart. I calculated the YTD info using below formula:   JPM Account Segment YTD = TOTALYTD([...

Re: Lab 4 -Exercise 3

Problem solved. First download the Gateway installation file, then open this file to install the Gateway. You will then get an option to load using the "Personal" method. After doin this, I can then ...

M Language question: A Column contains a List and a Record both types

Hi all,   I'm using pagination to get data from a REST API. The API works fine but results in like this:     As you see the engagement column contains a List and a Record as...

Re: Drillthrough: Have all filtered slicer values remain in target report

To clarify, the "Manager" Slicer exists on the Target page, not the Source.  The Target Report page contains a Bar Chart with the Manager's name that serves as the drillthrough filter to the Tar...

Re: How can I divide a column by a fixed value

Firstly, add ALL(dColigada) to your CALCULATE. I assume this is your second level row.   My second level row is dRazao. I tried with dRazao and with dColigada, but failed both. It Shows alway...

Calculate Total of Time Not Working

I have a table of times people are in an OR Room. Each row has a Start Time and End Time. Example: OR 1    07:05     09:15 OR 1    09:45     11:15...

Re: Summarize table depending on several fact tables

@Markando where are you summarising at the moment, in a new table?  or not ? sorry it would be best if i could see what you were actually doing? and the error or result you getting   ...

Re: Move up values field on column matrix

@v-juanli-msft thanks for your reply. I was affraid that is the case. Anyone knows any workaround for this feature?   The idea is already exists, maybe is not clear enough, but please vot...

Re: Display Yesterdays Data (Monday displays last work day aka Friday)

Take a look at this Quick Measure I just posted. You should be able to use this to simply filter to the current working day number minus 1.   https://community.powerbi.com/t5/Quick-Measures-Ga...

Re: Trend Line in Power BI

I am aware that Trend Line is not available in stacked column. But is there any other way to do. May be manually.   Also I tried on Clustered column chart with X-axis being categorical st...

Re: percentage

Thank you Lydia for reply. No, grand total option doesn't meet my requirements. Actually I need it to be displayed as a percentage of the definite value -"TD" among other values in that column "R". ...

Re: percentage

Here is it. I want the second plot be expressed in percents. Green and black columns suppose 2 cases. Another words I need number 200 being calculated as follows 200/543*100%. Thank you! And could ...

Re: Salesforce Data Refresh - Data Incomplete

Hi @alex1300au,   Did you get any error message when refreshing data?   Regards, Yuliana Gu

Re: Filter a Table based on Column 1 contains "Text1" and Column 2 contains "Text2&am

Yeah and I don't know when it arrived but it was available in India at that time, I think end of Feb and not Jan, sorry. It is also available online at Amazon India for a long time now, here is the ...

Re: Datesbetween - Line Chart Visualisation

@CNH, Please check the following PBIX file. https://1drv.ms/u/s!AhsotbnGu1NokzPRuVppwzju4CmB Regards, Lydia

Slicer doesnt work on DateTime column field

Hello Experts,   I have used slicer in report and the field I passed to it is of type "DateTime". It contains Date and time both. But the slicer shows only date filter and calendar. There is n...

Re: Change of financial year

Hi CheenuSing Sorry, I forgot to add that I am using the online PowerBI and our data is imported automatically from accounting software called Xero. Can this be done with the online PowerBI? T...

Re: How can I get a slicer with HH:MM

@vpertuz, The built-in slicer doesn't provide date/time format as you describe, there is an idea about this issue, please vote it up. In addition, you can check if Advanced Time slicer custo...

Re: Treemap - dynamic grouping question.

This is the sample data i am working on,I have created a column "Color" using DAX query "Color = if(Table1[Column1]>90,"GREEN","RED")" . After that for the treemap visualisation,I have added thes...

Re: Show line instead of dot in line chart

HI @GeorgiBarov,   Please provide more detailed information about your issue, it hard to clarify your scenario based on single screenshots.   BTW, if you axis field stored date...