Поддержка по Power BI

Поиск

Re: Issues with dates in Columns

Hi @Alonso1980 This table structure won't work because the columns seem to have different datatypes. Either that or the data is unpivoted.   Could you provide a more structured data (maybe us...

Re: Power BI - NEW WORKSPACES corrupted after publishing report with Composite Models

Hi @Agostinho_Fer,   When you mention the report contains  Composite Models, which data source does the report get data from. I see you mention the  SQL and Azure Analysis Ser...

Re: Issues while creating relationships between sharepoint online list and excel sheet

Hi @WaleedBinAfzal,   As the error message, you cannot create relationship if the column contains null values. So you can replace the null to other values and try again. If the issue st...

Re: Drill down functionality enables visual level filters

Hi @robstewart89,   I was not able to reproduce the same scenario on my side. In my test, drill down action didn't apply visual level filters. If possible, could you please share a samp...

Re: Slicer with Multi Select should not select more 2 Values

The Slicer in Power BI can only be set as Single or Multiple selections. You cannot limit the max selections in it in the current version of Power BI. You post your request into MS ideas board https:...

Re: If error showing blank instead of value I want in If Error

Hi MFelix, Thanks for your reply, It's a calculated column and the syntax is: IFERROR( IF(column A) = "Yes", "na", IF(column B) =Blank(), "No Record", Lookupvalue(lookupgroupZ, lookupgroupco...

Re: Hiding missing values in a line chart (direct query)

Hi @v-juanli-msft!   I have attached a table with sample data:     As you can see, the gaps in data occur on weekends. I am connected to a model using Direct Query and ...

Re: calculate counts for dates and show them in a bar chart

Hi @Angela123,   Does that make sense? If so, kindly mark my answer as a solution to close the case. Regards, Frank

Re: Clustering with multi columns

Thank you for the direction.   It works nicely, but I am missing some understanding as to the use of the few available fields.   Values - I did put the 6 numeric columns. Data Poi...

Re: 0365 Audit Logs Broke?

Hi All,   This issue has been fixed.     Best Regards, Dale

Re: Dynamic Row Level Security with Two path?

Hi @nisuomi, Based on my research, you could refer to below blog that may help you to create dynamic RLS rules with different paths: http://radacad.com/dynamic-row-level-security-with-organi...

Need your help with a measure (dashboard)

Hello,   I need your help with a measure. Right now i have a measure displaying the performance per supervisor, filtered per week by the page filter.   What I want is a line graph disp...

Re: count of id

@vmakhija I tried both but same error

Live connection back to local or merge 2 power BI files

Hi everyone,   due to compliance reasons we have to change our current report, which includes one dataset in PowerBI service (live conneciton) and one report as pbix, into one local pbix file....

Re: set active page in report with JavaScript API.

the problem is that this is not user friendly, the first page loads ... then gets changed to page x. I don't understand why the documentation says something and when you can to implement it, it does...

Re: Two Date Slicers and Filter in DAX measure

Hi,   I actually found a workaround by editing the interaction of the first Date filter so that it does not affect this KPI but it is not ideal. I would rather fix the formula itself. Wil...

Re: Not able to add datasource to gateway

@v-lili6-msft im aware the gateway is not needed but why am i not able to add it to gateway? is it not supported? and if i add it to gateway does it make any difference? is direct refresh better...

Re: DATEDIFF, calculate days between today and SQL date field, error

Seems like this should be the one:   Age = DATEDIFF(UTCTODAY(), 'Contas correntes de clientes'[dataven], DAY)   Is this a column or a measure?   This is what work...

Table Transformation Question

In PowerBI desktop, I have created a Web connection to a table of data that appears as follow:     How can I edit the query so that data is organized as illustrated below?   ...

Re: Show ToolTip when hovering over an image

Yep that is exactly what I wanted also.  I have an image.  I have an action on it.  I would like to say: "Click here to show menu"

Re: IF statement in measure gives blank

OK, so on a whim, have you tried this?   Measure 1:=IF(([Round or roundup])="0",10,20) 

Re: DATEDIFF, calculate days between today and SQL date field, error

It seems like you have plus symbols (+) where you should have commas (,) or semi-colons (.    I am unaware of a regional language variation that uses + symbols like that...

Re: Dropdown checkbox slicer

Sorry if I was not clear. I already have implemented custom visuals before. What I cannot do is find a way to RE-USE an existing control so that my control can behave consistently with other Power BI...

Re: Cannot pin visualization with custom theme

@v-qiuyu-msft We are still having the issue as well. Are they still working to fix it?   Thanks, Erika

Re: Previous Month vs 2 month ago

Thank you for your example but i don't be able to works it