Power BI Desteği

Arama

Re: Switch true does not keep the format of my measure

Hi @DM_BI,   Please modify the measure formula as: Indicateur = IF ( ISCROSSFILTERED ( SelectMeasure[Measure] ), SWITCH ( TRUE (), VALUES ( SelectMeasure[...

Re: Highlight max value in column chart

MMM-YYYY default option is not possible but MMMM yyyy is:  

Report tooltip

Hi   I have created one report page as Tooltip abd I am using Table view in the same. When I am using this report tooltip on another report, I am able to scroll up and down table view which is...

Issue with connecting to Odata in dataflows

Hello,  I'm having an issue when I attempt to connect to a Odata source in dataflows.  When i attempt to veryfy credentials through organisational account the prompt does not let me l...

DAX Calculate IN

Hello, I'm pretty new to writing DAX.   I've created Measure that CALCULATE SUM of VALUE IN specified PERIOD   Here is a formula: Plan III'18 = CALCULATE( SUM(Table[Plan]); Table...

Re: Group By and Then Sum Values

Exactly, there are multiple " Tipo_Processo_SGC", I would need to group them differently and then use them as dimension line in my table. 

Re: subtract one percentage from another DAX

Thanks for th excellent feedback jimmy, let me test the solution

Wrong location in map

Hi I have trouble getting my maps to show correct locations on the map. For example, it puts a Norwegian city in Australia. This also happens to several different postal codes / cities in South Amer...

Count ID's among hierarchies Paths in DAX

  HI DATANUTS!!!   For sure this is a simple one.   I have an UNPIVOTED hierarchies table "[DIM_SET]". Some characteristics of this table are:   Children levels with multi...

Slicer Multi selected values to Filter by Column which is not having any relation

Hi Im trying to Achieve below in Jan version of PowerBi,   i have a dimension table tblDimdate which has fldYear and another transaction table tblTransactions which i want a caluculation of f...

Re: tab pages clear

@ThomasBP, You can consider to configure bookmarks in the Power BI report. Regards, Lydia

Re: Data Sources available for free users

@Pulkit,   Free user can use all the built-in data source connect and configure schedule refresh in power bi service. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-data-...

Re: Inconsistent date format in refresh history of PowerBI service

@littlejjqwerty , Based on your screenshot, the date are in M/D/yyyy format( from 1/1 1 /2019 to 2/5/2019), do you want to change it to D/M/YYYY format? If so, you would need to set browser la...

Re: Setting a field to null based on another field's value

Hi @SantiagoMKE,   You can add a calculated column. Completeed Date2 = IF ( TB3[Sprint] = CALCULATE ( MAX ( TB3[Sprint] ), ALLEXCEPT ( TB3, TB3[Story] ) ), TB3[Completed Date]...

Re: Is it possible to display on Apple Watch a Report deployed on an on premise Power BI Report serv

Thank you Maya for your precious support. It's highly appreciated.   Have a nice day, Roberto.

Re: Calculated column to show duplicate/common items and hide uncommon items

Below is the model column. Follow its pattern for the other two.   This definition will give you a TRUE/FALSE for every row, even if it's not a Vendor A,B row. If you only want to show t...

Dax, Average + IsFiltered

Hello, all.   date category name unit countUnit tradePoint Zone 01.01.2019 Bike Bike1 356 1A A 02.01.2019 Bike Bike2 388 6C C 03.01.2019 Bike Bike3 176 9C C ...

Re: Historic Data by Week Number, Creating a Current Week X-Axis

@v-jiascu-msft Many Thanks for this. So here is my DAX   _Incident_Arrivals = CALCULATE(COUNTROWS(Incidents),USERELATIONSHIP(Added_Date[DATEKEY],Incidents[Added_Date_Key]))   a...

Re: PBI doesn't add the first three lines of the script when I press "Edit script in external R

@alonso_ogueda, I found a solution to this. In Power BI you can go to File > Options > R Scripting and change the temporary storage location. Once you select a folder to store your data...

Calculated column to show duplicate/common items and hide uncommon items

Hi everyone,   Here is my table called "Data":   Vendor Size Group Model Product Number Quantity Cost TAT Posting Date A S A150 5 150 450 67 July 7, 2018 A M A2...

Measure that ignores page filters that affect specific columns. ALLEXCEPT not working as expected.

If I have two slicers (or more) on a page affecting different columns on my base table, and wish to create a measure that ignores only one of the filters, how do I go about this?   Editing int...

Re: A table of multiple values was supplied where a single value was expected.

Hi Yuliana,   Thank you. I have sent a sample report to your email id.   The report works fine in power BI desktop but when you publish to workspace and open in workspace then the table...

Re: How can i user sort by other column in live/direct query to SQL server table

Wasn't working for me...      Have a TEXT field with the Month names, and a numeric field for each month's number. With the TEXT field as the X-Axis, I then select SortBy Column, se...

Re: Date Table Help - Week Ending

Perhaps my Week Ending Quick Measure?   https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293