Skip to main content

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([...

Creating date based measures

I have a table called "HelpDeskIncidents" that includes columns such as "OpenDate" "ClosedDate" and "IncidentNumber"   I want to be able to show, in one visual, the number of tickets opened AN...

Re: Column from Different Tables

Hey @Hactogeek, thanks for the reply.   I'm not sure what I'm doing wrong here, can you help me once more?   let     Source = Cost,     #"Type modifié" =...

Re: Level of detail calculation (Fixed / tableau software)

Just create a measure like this:   Total Sales = SUM(Table[Sales]) Create a table visualization that has [Country] and [Total Sales] in it.   If you want this to be "durable" or "fixed...

Re: "Flag" each month between two dates

I'm sorry, I can't download the file:  

Re: Can´t create a relationship between two columns because one of the columns must have unique valu

what if in some cases you have header and lines situation. meaning a table captures information at header level with a unique id and another table captures information at line level with stamping the...

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...

totalqtd not returning values for last week in the quarter

Hi   I have a formula which calculates the cumulative QTD target figures like so   Cumulative Q BPD Target = TOTALQTD('Targets'[target],'Full Date Table'[Date])   where full date...

Re: Power KPI Matrix Visual - Comparison Value not displayed

hello, thanks for your response. Yes I tried the sample data and that works for. However trying the same visual version with my one data fails. I like to share my sample file, https:/...

Re: Treemap - dynamic grouping question.

https://community.powerbi.com/t5/Desktop/Anyone-knows-how-to-attach-sample-files-to-a-post-here/td-p/91456 Kindly attach your file 

Storing Power BI Embedded Report settings or programmatically updating selections

Hi,   I am using PowerBI Embedded to embed a report in a demo website.   I need to be able to store the selections a user makes on a slicer visual between user sessions but I can't figu...

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". ...