Power BI のサポート

検索

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: 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: Creating date based measures

Here's a simplified version (attached). Just need 2 date tables.    

Re: Creating date based measures

OK, a bit different than I originally planned, but check this out (attached).  

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

Have a look at my Quick Measure here:   https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Last-Working-Days/m-p/391545   Should be able to write the logic that if it is Mond...

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

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

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

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: Countif for row based count (A:A=A2)

Hi @Raindeer,   You have to ways of doind this in PBI.   1 - Create a table with the Lookup values column (with unique values) and another one with date then just make a relationsh...

Re: How to fill the gaps in values between dates

Appreciated,  Sam! Thank you very much!

Re: Passing parameters to a Power BI report in Power BI Report Server

How we can pass dax function username() to sql query query to fetch data only for logged in user?    How we can pass dax function username or userprinciple name to sql query to retrive d...

Re: "Legend Style": Where art thou?

Try to place this question on the issues or ideas to check if someone does the follow up on this.   Regards, MFelix

Download reports links at once from workspace

Is there anyway to download report links from a workspace at once. We need to design a report index. Reports are under development stage,and the links constantly changing.

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

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