Supporto di Power BI

Cerca

Re: Donut tooltip is not coming in dashboard

Hi @PraveenRaj,   Based on my test, if we pin a report live page to a dashboard, the report page tooltip which contains Donut visual can display fine when we hover on the line chart vis...

Authoritative source explaining FIELDS list icons

Hello,   Is there a Microsoft document/link that explains the meanings of different ICONS in FIELDS list in Power BI Desktop?    For example, the below is from "Retail Analysis Sam...

Re: Return Value based on Multiple Distinct Values in different column

See if this works:   Column = VAR __table = FILTER(ALL('Table18'),[Unique ID] = EARLIER([Unique ID])) RETURN SWITCH(TRUE(), CONTAINS(__table,[Payment Types],"Payment Scheme"),"Payment S...

Re: Date Slicer Between has "wrong" values

Is it in the proper date format, please change it to year.

Re: Values do not appear

Try setting your x-axis to Continuous and your Label density to 100%

Re: Does not publish but says published successfully

Yes I have double checked. I am publishing it to the correct workspace

Re: "This table is empty" - Shows Headers but No Rows

Hi @Jaf017,   While the loaded table from DB2 shows empty in desktop, click the refresh button to see if it works. Besides, you could break the SQL Query into two, so that you load the ...

DAX and table structure/relationships advice

Hi   I'm building a portfolio reporting tool which monitors financial spend on projects. Part of my data model includes the three tables shown and described below:   Project details - m...

Re: Hiding visual resets filter?

Hmm, will have to test. To be clear, you don't want the filter to be reset, correct? I would think you would need the data checkbox checked for that...

Re: Display value from Column

So, a column form of this would be:   Column = SWITCH(TRUE() ISBLANK([Order No]) && ISBLANK([PO No]),"Unprocessed", ISBLANK([Order No[), [Po No], [Order No] )

Re: Does not publish but says published successfully

Don't get how could that be the issue. As I have deleted a visual and put a completely different one on that location and once I publish it neither the old visual is deleted neither the new one added.

Power BI Newbie - Dax Formula Help

Hi,   I have two tables with a collumn in each in which i need to pull a value from the first table and collumn, if a particular value is present then present this in a new collumn (do not ref...

Re: excel dataflow filepath setup issue

Hi there Yes I totally forgot because dataflows are a cloud based service, if you are connecting to any file that is not cloud sourced, you would need the Gateway to connect to the file.

Re: RANKX issue: dynamic index column with multiple filters

I just added the filters in an ALLEXPECT and now it works perfectly - thank you so much!

what are the limitations of sybase, IBM's, postgresql with power bi?

Hi all, I need some information like what are the limitations of sybase, postgresql and IBM DB2 database when connected in power bi *(when used in power bi). can you any please reply on this with ref...

Re: How can I create a simple index column with dax.

I created a calculation called Sequential once, but this is going to depend on what is in your table, can you share that or an example?   https://community.powerbi.com/t5/Quick-Measures-Gall...

Re: High density sampling (error?)

hi Yuliana @v-yulgu-msft   Ideally, my desired output is for all 166 series to be visible. If that option is not available, I'd be content with what High Density Sampling is purported to ...

Can I color the image inserted based on the result?

Hi all,   I am trying to measuring performance of each market (e.g. US, Canada , Europe etc) and want to displayed the result with map. Can I insert my map and image and colour it based on th...

Re: Help writing DAX measure

Hi Tampton,   First you need to have a date column with DD/MM/YYYY, and use DATESMTD function to get desired results.   Regards, Pavan Vanguri.

Re: Get the list of User form the previous month not included in the range.

I finally could have the measure I wanted with : Churn = VAR previousMinMonth = PREVIOUSMONTH ( 'Date'[Date] ) VAR listOfAssociationIdInRange = DISTINCT( Paiements[id_association]) VAR ...

Re: How to implement Row Level Security in Power BI Embedded?

Thanks for your response.   I am using User-Owns-Data to implement my requirement.   I have successfully implemented displaying reports list based on workspace/group id and able ...

Using PATH(), How Do I Remove Blanks From My Hierarchy Between Levels?

Hello awesome communty!   I'm learning the PATH() function, what I'm doing is, I want to create a product category hierarchy, I'm getting a table from Dynamics 365 F&O called "RetailProduc...

Re: Total average

Hi Frank   Sorry for my late reply    The real data is confidential, therefore I made a quick BI with sample data, and tried to build up almost the same scenario. Link to BI Test ...

Group by category calculation

Please help me to find correct answer: Fact Table: FactStudent SchoolId StudId InSession   S1 11 5 SchoolLevelP = DISTINCT COUNT(StudId (NOTE: Those are in insession ...

Re: Disable cross filter direction DAX

@Greg_Decklerthank you for respons. I did it like this with ALL. I addded new DAx table and new cross fileter single connection And I get it OK, but I was wondering is there a way to do tha...