Supporto di Power BI

Cerca

Dynamic Dashboards

I am curious if it is possible to create a Dynamic Dashboard in Power BI. I assume it is not but figured I would pose the question.   The reason I ask is we often have the requirement to show ...

Re: Editing information directly into Power BI Service

Hi there You are correct, that you cannot enter data directly in the Power BI Service. With that being said, you could create a Power App, which you could embed into your Power BI Report, which...

Re: On Prem Gateway Cluster - Change Primary

Hi Lydia,   Thank you for the reply here.  That's roughly what I tried previously (see message above), with the exception that I had done a 'take-over' of Gateway A by Gateway B afte...

Re: Date/Calendar Table

Hi @mynameisrichard,   If you want to use the calendar date to filter source data model, you have to create a relationship between them. For which date column should be linked to, it de...

Re: Copying reports from one workspace to another workspace using Power BI Rest APIs

Hi @Sandhyarani958,   For duplicate workspace and its contents, you can refer to following blog to know more about this: (based on rest api and powershell script) Duplicate workspaces...

Re: Pictures in bar graph

Hi @indhu,   Currently, it is not possible to display images on chart axis.  To help improve Power BI, you could submit an idea on https://ideas.powerbi.com/forums/265200...

Re: Incremental refresh with SQL date filter

Thanks, but that article doesn't seem to answer my question. I guess my question needs to be clarified more.   In the SQL statement there is a static date filter set for 1.3.2018, so I w...

Importing an .ics file - calendar

does anyone know the best way of importing an .ics file into power bi?

Re: Extract Lat and Long from a Google URL keep in csv file

Hi @mrbajana, Based on my test, you could refer to below steps in query editor: Spilt the column by "@" Split the new column by "/" Split the new column by "," and remove the oth...

Re: Dynamic TopN made easy with What If Parameter

Hi there you could try the ALLEXCEPT which will change the filter context to select everything except what you select 

Re: Using r to pull data from app.powerbi.com

Hi @bwwhite,   Nope, power bi service not support to use r script.(editor functions and coding formula has been disabled on power bi service side) You can only consider to use existed...

the start date in Calendar function cannot be later than the end date

I have prepared below formula for Age Days calculation previously it is working fine. when I have connected dashboard with Production database I am getting an error in this formula: the start date in...

Re: Annual Percent Change

Hi @LakiCG,   You can try to use below measure if it works for your scenario: Change % with Prev Year = VAR _Curr = CALCULATE ( AVERAGE ( Table1[Rent] ), ...

Negative values to be displayed prepend with brackets

Hi there,     We have certain problem in converting the minus (-) sign into Brackets ' (  ) 'sign for the numerical values on the Matrix visual. There is a solution for string values,...

Re: Date Table For Year over Year Calculations At The Daily Level.

Hi @lemarcfj,   >>For example, Monday August 20, 2018 is Sunday August 20, 2017 - so comparing these two days on a visual wouldn't be accurate. I would need to compare to Monday A...

Re: Publishing from desktop application to group workspace? Still not possible?

Strange thing is that when i press the Publish button, i dont get Select a destination  box.

Re: Date Hierarchy Returning (blanks) in Charts

HI @joshbm1121,   Please provide more detail information to help us clarify your scenario, it is hard to troubleshooting from your description and snapshot. How to Get Your Question A...

Re: Publishing from Desktop to a workspace created in the new workspace (preview)

Hi @tglah,   I have tested again but I cannot reproduce your issue.   You could have a try if you could get data —— File—— your pbix file in the new app workspace (Preview)? ...

Re: Fiscal Year Calculated Columns

Hi @marcus505,   Yes, here you should update your formula like this.   Measure = CALCULATE(SUM(fabric_swishs[fabric_typeofcaller]),FILTER(fabric_swishs,fabric_swishs[fabric_dateofc...

Re: Search for multiple selections from filter

Hi @molloyky,   I modify formula to work through convert search function result as boolean: Total Tickets = VAR logicAction = SWITCH ( MAX ( 'Action'[Tag Action] ), ...

Use proxy to access bigquery from Desktop throught proxy

Hi,   I can't connect to bigQuery from Desktop throught internet proxy. It's works with a 4G hotspot.   How can I force desktop to use system proxy ? Or it's possible to modify a confi...

Re: Power BI Service SQL Connection Error

Hi @chawkinsitron,   Based on your error message, it seems that the issue is caused by the  credential you connect to the data source is invalid.   What kind of credenti...

Re: Showing data points on line graph

@rachel65,   You may take a look at the post below. https://community.powerbi.com/t5/Desktop/Where-is-the-quot-Show-Marker-quot-in-the-Line-Chart/td-p/247863

Re: Dynamic TopN made easy with What If Parameter

I just measured it and it took about 2 min 25 sec to filter top15 results

Re: SUMMARIZE Measure with Calculated Column

Hi @Eddie_D   You may try to use Date Function to get the StartDate as below: StartDate = VAR EndDate = MAX ( 'Calendar'[Date] ) RETURN DATE ( YEAR ( EndDate ) - 1, MONTH ( ...