Supporto di Power BI

Cerca

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: How do I add a user input fields and compare the values related to input

@hansel   you need to create two disconnected tables containing the unique months list       Then add the two silcers and these two measures:   New Customers = ...

count rows and save it in a new column

Hi everyone,  I have this table,where  I want to add column "count" ,which contains number of how many times this user appears in the table. Here is the sample,what I am trying to get. &...

Re: Write code in easier way

Hi,    Thank you very much! It work great.   Regards  Albin

Power bi measure ISBLANK AND NOT ISBLANK

Hi there,   I'm just started with a report of a file server scan. I have a excel file with all the files and folders of a file share. The column of the path (file path), I already did split i...

Re: Drill down functionality enables visual level filters

Hi @v-yulgu-msft   The Pbix file is: Power BI - Drilldown Errors   I've also attached a .gif below of what I'm seeing (hopefully it works!)       &nbs...

Re: Update parameters- DMTS_SetParametersMonikersErrorCode

I was resolved! i had a mistake in value of one parameter.    thanks for your help!

Re: Cannot convert value to type table

I have the exact same issue happening with this line        #"Expanded helpdesk-ticket.custom_field" = Table.ExpandTableColumn(#"Removed Columns", "helpdesk-ticket.custom_f...

Re: Total sum of fractions doesn't equal 1.

Hi - I just pulled in a view from our database.  As soon as I try to scroll left or right to see the additional columns, that error pops up.  Maybe it has to do with the data quality previe...

Re: Prior Period Comparative Dynamic Date Range

Dear Rafael - thanks for a reponse. Apologies I should have addedd sample data to the original post.   There are two tables - ''Dates'', and ''Revenue'' and the only relationship is the link b...

Re: Increase and decrease status

@Naveennegi119   First add an index colum from Query Editor Then you can use this column   Column = VAR previousvalue = CALCULATE ( MIN ( Table1[Value] ), FILT...